Creates a bullet chart that is rendered in an Excel cell.
Double-clicking the chart, or selecting the FluenceXL > 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
|
| 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
