Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3SparkLolliplot

    Creates a lollipo chart that is rendered in an Excel cell, this formula was introduced in Version 7.1

    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 Lollipop Chart Designer.

    Syntax

    XL3SparkBar( Data, Output, InRows, Width, [ColourBar], [ColourPop], [ColourNegBar], [ColourNegPop], [Minimum], [Maximum], [AxisType], [MajorTickmarkFrequency], [MinorTickmarksPerMajor], [TickmarkLabelFormatString], [Label], [Reference], [Reference Colour] )

    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
    Width The width of the chart
    ColourBar The colour for the bar, or -1 or an empty parameter for default
    ColourPop The colour for the "Pop", or -1 or an empty parameter for default
    NegColourBar The colour for the bar for negative values, or -1 or an empty parameter for default
    NegColourPop The colour for the "Pop" for negative values, or -1 or an empty parameter for default
    Minimum A value to use for the minimum horizontal axis value, or an empty parameter to use an automatic value
    Maximum A value to use for the maximum horizontal axis value, or an empty parameter to use an automatic value
    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, if no axis is used
    Reference A range or value to use for a reference value, drawn as a vertical bar.
    ReferenceColour The colour of the reference value bar


    See Also