Creates a dot plot that is rendered in an Excel cell.

Double-clicking the chart, or selecting the Anaplan XL > Format In-Cell Chart... right-click menu item enables 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

ParameterDescription
DataThe data to chart. This can be a range or a formula.
OutputThe target range in which to render the chart(s).
InRows

Specifies whether the input data are in rows or columns:

  • 0 – Data is in rows
  • 1 – Data is in columns
PlotType

The shape to use for the points:

  • 0 – Dots
  • 1 - Circles
StackType

Clumps of data points are drawn either on top of each other, varying the y-position, or color:

  • 0 – None
  • 1 – Position
  • 2 - Color
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 of the same shape as the source values to enable 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 enable dots near each other to be easily distinguished (only applied when StackType is 1 - Position)
StackDataThe alternate data range to use when StackValueType is 1 (Values).
Colour1 ... Colour8The color to use for the corresponding data point, or -1 or an empty parameter for default.
MinimumA value to use for the minimum horizontal axis value, or an empty parameter to use an automatic value.
MaximumA value to use for the maximum horizontal axis value, or an empty parameter to use an automatic value.
YMinimumA value to use for the minimum vertical axis value, or an empty parameter to use an automatic value.
YMaximumA 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
MajorTickmarkFrequencyThe frequency of the major, labeled tickmarks.
MinorTickmarksPerMajorThe number of additional labelless tickmarks per major tickmark.
TickmarkLabelFormatStringThe format string for the axis tickmark labels.
LabelSpecifies the text to use in the formula cell.