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

    Creates a dot plot 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 DotPlot Chart Designer.

    Syntax

    XL3SparkDotPlot( Data, Output, InRows, Length, PlotType, StackType, StackValueType, StackData, [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [Colour6], [Colour7], [Colour8], [Minimum], [Maximum], [YMinimum], [YMaximum], [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
    PlotType The shape to use for the points:
    0 Dots XL3SparkDotPlot Dots.png
    1 Circles XL3SparkDotPlot Circles.png
    StackType Clumps of data points are drawn either on top of each other, varying the y-position, or colour:
    0 None XL3SparkDotPlot StackNone.png
    1 Position XL3SparkDotPlot StackPosition.png
    2 Colour XL3SparkDotPlot StackColour.png
    StackValueType Defines how dots are stacked - the number of values, an alternate set of values or a random jitter:
    0 Count The Y value is defined by the number of values that are the same (only applied when StackType is 1 or 2 - Position or Colour)
    1 Values Provide another range the same shape as the source values to allow plotting of specific X and Y values (only applied when StackType is 1 or 2 - Position or Colour)
    2 Jitter The Y value is taken from a fixed set of random values to allow dots near each other to be easily distinguished (only applied when StackType is 1 - Position)
    StackData The alternate data range to use when StackValueType is 1 (Values)
    Colour1 ... Colour8 The colour to use for the corresponding data point, 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
    YMinimum A value to use for the minimum vertical axis value, or an empty parameter to use an automatic value
    YMaximum A value to use for the maximum vertical 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

    See Also