Creates a win/loss chart that is rendered in an Excel cell.
Double-click the chart, or select the Anaplan XL > Format In-Cell Chart... right-click menu item to edit the chart format using the SparkWinLose Chart Designer.
Syntax
XL3SparkWinLose( Data, Output, InRows, [WinColour], [LossColour], [DrawColour], [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:
|
| WinColour | The color to use for win columns. |
| LossColour | The color to use for loss columns. |
| DrawColour | The color to use for drawing columns. |
| Label | Specifies the text to use in the formula cell. |
