| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3SparkWinLose
Revision as of 15:38, 19 November 2010 by Antonio.remedios (talk | contribs) (Created page with 'Creates a win/loss chart that is rendered in an Excel cell. ==Syntax== {{Code|XL3SparkWinLose( Data, Output, InRows, [WinColour], [LossColour], [DrawColour], [Label] )}} ==Para…')
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:
| ||||
| 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 |
