Creates a win/loss chart that is rendered in an Excel cell.
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:
| 0 |
Data are in rows
|
| 1 |
Data are in columns
|
|
| WinColour
|
The colour to use for win columns
|
| LossColour
|
The colour to use for loss columns
|
| DrawColour
|
The colour to use for draw columns
|
| Label
|
Specifies the text to use in the formula cell
|
See Also
