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

ParameterDescription
DataThe data to chart. This can be a range or a formula.
OutputThe target range in which to render the chart(s).
InRows

Specifies whether the input data are in rows or columns:

  • 0 – Data are in rows
  • 1 – Data are in columns
WinColourThe color to use for win columns.
LossColourThe color to use for loss columns.
DrawColourThe color to use for drawing columns.
LabelSpecifies the text to use in the formula cell.