Creates a lollipop chart that is rendered in an Excel cell, this formula was introduced in Version 7.1
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 Lollipop Chart Designer.
Syntax
XL3SparkLolliplot( Data, Output, InRows, Width, [ColourBar], [ColourPop], [ColourNegBar], [ColourNegPop], [Minimum], [Maximum], [AxisType], [MajorTickmarkFrequency], [MinorTickmarksPerMajor], [TickmarkLabelFormatString], [Label], [Reference], [Reference Colour], [Square Pop], [Data Label Align], [Font Name], [Font Size], [Format String], [Data Label Color], [Data Label Bold], [Reverse Formatting], [Exclude Outliers], [Inline Axis Type])
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
|
| Square Pop
|
Use square pop instead of round, 0/1.
|
| Data Label Align
|
Alignment of the labels
|
| Font Name
|
Label text font.
|
| Font Size
|
Label text size.
|
| Format String
|
Label number format.
|
| Data Label Color
|
Label text color.
|
| Data Label Bold
|
Label text bold, 0/1.
|
| Reverse Formatting
|
Reverse colour formatting, e.g. for revenure vs expense, 0/1. Can come from a range so varies per chart.
|
| Exclude Outliers
|
Outliers are represented by an arrow so they do not shrink other values.
|
| Inline Axis Type
|
Vertical axis type:
| 0 |
No axis
|
| 1 |
Standard
|
| 2 |
Plan, double line
|
|
See Also
