XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XL3SparkLolliplot"

(→‎Syntax)
 
Line 77: Line 77:
 
| {{Code|ReferenceColour}}
 
| {{Code|ReferenceColour}}
 
| The colour of the reference value bar
 
| The colour of the reference value bar
−
 
+
|-
−
 
+
| {{Code|Square Pop}}
 +
| Use square pop instead of round, 0/1.
 +
|-
 +
| {{Code|Data Label Align}}
 +
| Alignment of the labels
 +
|-
 +
| {{Code|Font Name}}
 +
| Label text font.
 +
|-
 +
| {{Code|Font Size}}
 +
| Label text size.
 +
|-
 +
| {{Code|Format String}}
 +
| Label number format.
 +
|-
 +
| {{Code|Data Label Color}}
 +
| Label text color.
 +
|-
 +
| {{Code|Data Label Bold}}
 +
| Label text bold, 0/1.
 +
|-
 +
| {{Code|Reverse Formatting}}
 +
| Reverse colour formatting, e.g. for revenure vs expense, 0/1. Can come from a range so varies per chart.
 +
|-
 +
| {{Code|Exclude Outliers}}
 +
| Outliers are represented by an arrow so they do not shrink other values.
 +
|-
 +
| {{Code|Inline Axis Type}}
 +
| Vertical axis type:
 +
{|
 +
| 0 || No axis
 +
|-
 +
| 1 || Standard
 +
|-
 +
| 2 || Plan, double line
 +
|}
 
|}
 
|}
  

Latest revision as of 14:44, 26 September 2022

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 XLCubed > 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

Retrieved from ‘https://help.xlcubed.com/index.php?title=XL3SparkLolliplot&oldid=10800’