Creates a pie chart that is rendered in an Excel cell.
Double-clicking the chart or selecting the Anaplan XL > Format In-Cell Chart... right-click menu item enables the editing of the chart format using the SparkPie Chart Designer.
Syntax
XL3SparkPie( Data, Output, InRows, [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [Colour6], [Colour7], [Colour8], [Label] )
Parameters
| Parameter | Description |
| Data | The data to chart. This can be a range or a formula. |
| Output | The target range in which to render the chart(s). |
| InRows | Specifies whether the input data are in rows or columns:
|
| Colour1 | The color for the first sector, or -1, or an empty parameter for default. |
| Colour2 | The color for the second sector, or -1, or an empty parameter for default. |
| Colour3 | The color for the third sector, or -1, or an empty parameter for default. |
| Colour4 | The color for the fourth sector, or -1, or an empty parameter for default. |
| Colour5 | The color for the fifth sector, or -1, or an empty parameter for default. |
| Colour6 | The color for the sixth sector, or -1, or an empty parameter for default. |
| Colour7 | The color for the seventh sector, or -1, or an empty parameter for default. |
| Colour8 | The color for the eighth sector, or -1, or an empty parameter for default. |
| Label | Specifies the text to use in the formula cell. |
