Creates a bullet chart that is rendered in an Excel cell.

Double-clicking the chart, or selecting the Anaplan XL > Format In-Cell Chart... right-click menu item enables 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

ParameterDescription
DataThe data to chart. This can be a range or a formula.
OutputThe 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 shown on the chart:

  • 0 – Bar
  • 1 – Dot
WidthThe total length of the bullet chart.
PerformanceColourThe color for the performance measure, or -1 or an empty parameter for default.
QualitativeRangesValues specifying the ranges to draw on the chart. This can be a range or an array parameter.
Colour1The color for the first range, or -1 or an empty parameter for default.
Colour2The color for the second range, or -1 or an empty parameter for default.
Colour3The color for the third range, or -1 or an empty parameter for default.
Colour4The color for the fourth range, or -1 or an empty parameter for default.
Colour5The color for the fifth range, or -1 or an empty parameter for default.
RangeOrder-1 to reverse the range order.
ReferenceValuesReference values to show on the charts. This can be a range or a value.
ReferenceColourThe color for the reference value indicator, or -1 or an empty parameter for none.
ProjectionValuesProjection values to show on the charts. This can be a range or a value.
ProjectionColourThe color for the projection bar, or -1 or an empty parameter for none.
ReferenceValues2A second set of reference values to show on the charts. This can be a range or a value.
ReferenceColour2The color 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
MajorTickmarkFrequencyThe frequency of the major, labeled tickmarks.
MinorTickmarksPerMajorThe number of additional labelless tickmarks per major tickmark.
TickmarkLabelFormatStringThe format string for the axis tickmark labels.
LabelSpecifies the text to use in the formula cell.