| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3SparkWinLose"
(Added link to the monochrome version) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
Creates a win/loss chart that is rendered in an Excel cell. | Creates a win/loss chart that is rendered in an Excel cell. | ||
| + | |||
| + | Double-clicking the chart, or selecting the {{Menu|XLCubed|Format In-Cell Chart...}} right-click menu item allow the editing of the chart format using the [[SparkWinLose Chart Designer]]. | ||
==Syntax== | ==Syntax== | ||
| Line 38: | Line 40: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| − | * [[ | + | * [[XL3SparkWinLoseM|XL3SparkWinLoseM Formula]] |
| + | * [[SparkWinLose Chart Designer]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:In-Cell Chart Formulae]] | [[Category:In-Cell Chart Formulae]] | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
Latest revision as of 11:26, 1 December 2010
Creates a win/loss chart that is rendered in an Excel cell.
Double-clicking the chart, or selecting the XLCubed > Format In-Cell Chart... right-click menu item allow the editing of 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 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 |
