Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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