CELLCHART

Draw a chart inside a cell.

Syntax

=CELLCHART(DataRange, ChartType, LineColor, FillColor, Marker, Minimum, Maximum)

Arguments

NameDescription
DataRangeCell Range to retrieve the data for the chart from
CharrTypeOptional. Valid Chart Type. Default is line. Valid values are : line, column, bar, pie, doughnut, bubble, scatter, area.
LineColorOptional. Line Color to use for first series
FillColorOptional. Fill Color to use for first series
MinimumValue Axis Minimum
MaximumValue Axis Maximum

Return Value

TRUE, if chart could be created.

Example

FunctionResultComment
=CELLCHART(B2:B5, "pie")TRUEDraw a chart in the current cell.