Creates a lollipop chart 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 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

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
WidthThe width of the chart.
ColourBarThe color for the bar, or -1 or an empty parameter for default.
ColourPopThe color for the "Pop", or -1 or an empty parameter for default.
NegColourBarThe color for the bar for negative values, or -1 or an empty parameter for default.
NegColourPopThe color for the "Pop" for negative values, 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.
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, if no axis is used.
ReferenceA range or value to use as a reference value is drawn as a vertical bar.
ReferenceColourThe color of the reference value bar.
Square PopUse square pop instead of round, 0/1.
Data Label AlignAlignment of the labels.
Font NameLabel text font.
Font SizeLabel text size.
Format StringLabel number format.
Data Label ColorLabel text color.
Data Label BoldLabel text bold, 0/1.
Reverse FormattingReverse color formatting, for example, for revenue vs expense, 0/1. It can come from a range, so it varies per chart.
Exclude OutliersAn arrow represents outliers so they don't shrink other values.
Inline Axis Type

Vertical axis type:

  • 0 – No axis
  • 1 – Standard
  • 2 – Plan, double line