Skip to main content

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 or an Error Code

Example

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