Difference between revisions of "XL3SparkBullet"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
Line 1: | Line 1: | ||
Creates a bullet chart that is rendered in an Excel cell. | Creates a bullet chart that is rendered in an Excel cell. | ||
− | Double-clicking the chart, or selecting the {{Menu| | + | Double-clicking the chart, or selecting the {{Menu|FluenceXL|Format In-Cell Chart...}} right-click menu item allow the editing of the chart format using the [[SparkBullet Chart Designer]]. |
==Syntax== | ==Syntax== |
Latest revision as of 09:53, 4 July 2023
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:
| ||||||||||
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:
| ||||||||||
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 |