XL3SparkBullet

Creates a bullet 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 SparkBullet Chart Designer.

Syntax

XL3SparkBullet( Data, Output, InRows, [BulletType], [Width], [PerformanceColour], [QualitativeRanges], [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [RangeOrder], [ReferenceValues], [ReferenceColour], [ProjectionValues], [ProjectionColour], [ReferenceValues2], [ReferenceColour2], [AxisType], [MajorTickmarkFrequency], [MinorTickmarksPerMajor], [TickmarkLabelFormatString], [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:
0 Data are in rows
1 Data are in columns
BulletType Specifies how the performance measure is indicated on the chart
0 Bar
1 Dot
Width The total length of the bullet chart
PerformanceColour The colour for the performance measure, or -1 or an empty parameter for default
QualitativeRanges Values specifying the ranges to draw on the chart. This can be a range or an array parameter
Colour1 The colour for the first range, or -1 or an empty parameter for default
Colour2 The colour for the second range, or -1 or an empty parameter for default
Colour3 The colour for the third range, or -1 or an empty parameter for default
Colour4 The colour for the fourth range, or -1 or an empty parameter for default
Colour5 The colour for the fifth range, or -1 or an empty parameter for default
RangeOrder -1 to reverse the range order
ReferenceValues Reference values to indicate on the charts. This can be a range or a value
ReferenceColour The colour for the reference value indicator, or -1 or an empty parameter for none
ProjectionValues Projection values to indicate on the charts. This can be a range or a value
ProjectionColour The colour for the projection bar, or -1 or an empty parameter for none
ReferenceValues2 A second set of reference values to indicate on the charts. This can be a range or a value
ReferenceColour2 The colour for the second reference value indicator, or -1 or an empty parameter for none
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
MajorTickmarkFrequency The frequency of the major, labelled tickmarks
MinorTickmarksPerMajor The number of additional labelless tickmarks per major tickmark
TickmarkLabelFormatString The format string for the axis tickmark labels
Label Specifies the text to use in the formula cell

See Also