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

    Creates a BoxPlot (also known as a box-and-whisker diagram) 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 SparkBox Chart Designer.

    Syntax

    XL3SparkBox( Data, Output, InRows, [Width], [WhiskerColour], [BarColour], [BoxColour], [MedianColour], [BorderColour], [MeanDotColour], [UpperQuartileColour], [PercentileBoundary], [Minimum], [Maximum], [AxisType], [MajorTickmarkFrequency], [MinorTickmarksPerMajor], [TickmarkLabelFormatString], [Label], [WhiskerType], [DotType], [AdditionalVals1], [Val1Color], [AdditionalVals2], [Val2Color], [Val1Type], [Val2Type] )

    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 total length of the box plot
    WhiskerColour The colour to use for the whiskers, or -1 or an empty parameter for default
    BarColour The colour to use for the bar, or -1 or an empty parameter for default
    BoxColour The colour to fill the box representing the lower quartile, or -1 or an empty parameter for default
    MedianColour The colour to use for the median line, or -1 or an empty parameter for default
    BorderColour The colour to use for border of the box, or -1 or an empty parameter for default
    MeanDotColour The colour to use for the mean dot, or -1 or an empty parameter for default
    UpperQuartileColour The colour to fill the box representing the upper quartile, or -1 or an empty parameter for default
    PercentileBoundary **Currently Unknown
    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
    WhiskerType Reserved
    DotType Reserved
    AdditionalVals1 A range containing a additional series of values to plot
    Val1Color The colour to use to plot the values specified in AdditionalVals1
    AdditionalVals2 A range containing a second additional series of values to plot
    Val2Color The colour to use to plot the values specified in AdditionalVals2
    Val1Type The shape to use to plot the values for AdditionalVals1
    0 Points XL3SparkBox AdditionalPoints.png
    1 Lines XL3SparkBox AdditionalLines.png
    Val2Type The shape to use to plot the values for AdditionalVals2. Valid values are as Val1Type

    See Also