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

• Formula Reference
• SparkBullet Chart Designer
• Bullet graph on Wikipedia