CELLCHART
Draw a chart inside a cell.
Syntax
=CELLCHART(DataRange, [ChartType], [LineColor], [FillColor], [Minimum], [Maximum])
Arguments
| Name | Type | Description |
|---|---|---|
| DataRange | Range | Cell Range to retrieve the data for the chart from |
| ChartType (optional) | String | Valid Chart Type. Default is line. Valid values are : line, column, bar, pie, doughnut, bubble, scatter, area. |
| LineColor (optional) | String | Line Color to use for first series as hexadecimal color value |
| FillColor (optional) | String | Fill Color to use for first series as hexadecimal color value |
| Minimum (optional) | Number | Value Axis Minimum |
| Maximum (optional) | Number | Value Axis Maximum |
Return
TRUE or an Error Code
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Draw a chart in the current cell. |