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
