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) | ChartType | Valid Chart Type. Options: "line" "column" "bar" "pie" "doughnut" "bubble" "scatter" "area" Default value: "line" |
| LineColor (optional) | Color | Line Color to use for first series as hexadecimal color value Options: "none": Invisible "#FFFFFF": White "#000000": Black "#FF0000": Red "#00FF00": Green "#0000FF": Blue "#FFFF00": Yellow "#AAAAAA": Grey |
| FillColor (optional) | Color | Fill Color to use for first series as hexadecimal color value Options: "none": Invisible "#FFFFFF": White "#000000": Black "#FF0000": Red "#00FF00": Green "#0000FF": Blue "#FFFF00": Yellow "#AAAAAA": Grey |
| Minimum (optional) | Number | Value Axis Minimum |
| Maximum (optional) | Number | Value Axis Maximum |
Return
| Type | Description |
|---|---|
| Boolean | TRUE or an Error Code |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Draw a chart in the current cell. |