Difference between revisions of "XL3SparkBarM"
(Added link to coloured version) |
(→Parameters) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
==Syntax== | ==Syntax== | ||
| − | {{Code|XL3SparkBarM( Data )}} | + | {{Code|XL3SparkBarM( Data, [Max Value] )}} |
==Parameters== | ==Parameters== | ||
| Line 11: | Line 11: | ||
| {{Code|Data}} | | {{Code|Data}} | ||
| The data to chart. This can be a range or a formula | | The data to chart. This can be a range or a formula | ||
| + | |- | ||
| + | | {{Code|Max Value}} | ||
| + | | The max value of the data to chart. This can be a range or a formula. (New to [[Version 7.2]]) | ||
|} | |} | ||
Latest revision as of 15:12, 12 December 2012
Creates a monochrome bar chart that is rendered in the Excel cell.
Syntax
XL3SparkBarM( Data, [Max Value] )
Parameters
| Parameter | Description |
|---|---|
| Data | The data to chart. This can be a range or a formula |
| Max Value | The max value of the data to chart. This can be a range or a formula. (New to Version 7.2) |
