Difference between revisions of "XL3SparkBarM"
(Created page with 'Creates a monochrome bar chart that is rendered in the Excel cell. ==Syntax== {{Code|XL3SparkBarM( Data )}} ==Parameters== {| class="wikitable" ! Parameter ! Description |- | {…') |
(→Parameters) |
||
| (4 intermediate revisions by 2 users 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]]) | ||
|} | |} | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[XL3SparkBar|XL3SparkBar Formula]] | ||
[[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 14: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) |
