Creates a dot plot that is rendered in an Excel cell.
Double-clicking the chart, or selecting the FluenceXL > 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 |
|
| 1 |
Circles |
|
|
| StackType
|
Clumps of data points are drawn either on top of each other, varying the y-position, or colour:
| 0 |
None |
|
| 1 |
Position |
|
| 2 |
Colour |
|
|
| 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
