Creates a Comparison Chart that is rendered in an Excel cell, this formula was introduced in Version 10
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 Comparison Chart Designer
Syntax
XL3SparkCompare( Value1, Output, InRows, ChartType, Value2, Width, ColorVal1, ColorVal2, ColorNegBar, ColorNegPop, Minimum, Maximum, AxisType, Units, TickMarks, TickMarkFormat, Label)
Parameters
| Parameter
|
Description
|
| Value1
|
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
|
|
| ChartType
|
Choose from 4 different chart types:
|
| Value2
|
The range of data to use for comparison.
|
| Width
|
The width of the chart
|
| ColorVal1
|
The colour for a positive value, or an empty parameter for default
|
| ColorVal2
|
The color for an increase in value, or an empty parameter for default
|
| ColorNegBar
|
The colour for a negative value, or an empty parameter for default
|
| ColorNegPop
|
The colour for a decrease in value, or an empty parameter for default
|
| Minimum
|
A value to use for the minimum horizontal axis value, or an empty parameter to use an automatic value
|
| Maximum
|
A value to use for the maximum horizontal axis value, or an empty parameter to use an automatic value
|
| AxisType
|
The type of axis to render in the formula cell:
| 0 |
No axis
|
| 1 |
Draws the axis at the top of the cell, with tickmarks below
|
| 2 |
Draws the axis at the bottom of the cell, with tickmarks above
|
| 3 |
Draws the axis at the top of the cell, with tickmarks and labels below
|
| 4 |
Draws the axis at the bottom of the cell, with tickmarks and labels above
|
|
| Units
|
The frequency of the major, labelled tickmarks
|
| TickMarks
|
The number of additional labelless tickmarks per major tickmark
|
| TickMarkFormat
|
The format string for the axis tickmark labels
|
| Label
|
Specifies the text to use in the formula cell, if no axis is used
|
See Also
