Creates a bar 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 allows the editing of the chart format using the SparkBar Chart Designer.

Syntax

XL3SparkBar( Data, Output, InRows, [LongestBarLength], [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [Colour6], [Colour7], [Colour8], [IsStacked100%], [ShowZeros], [Minimum], [Maximum], [DataLabelAlign], [DataLabelFontName], [DataLabelFontSize], [DataLabelFormatString], [DataLabelFontStyle], [DataLabelColour], [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 are in rows
  • 1 – Data are in columns
LongestBarLengthThe length of the longest bar (in characters)
Colour1The color for the bar chart, or the first section in a stacked bar, or -1 or an empty parameter for default
Colour2The color for the second section, or -1 or an empty parameter for default
Colour3The color for the third section, or -1 or an empty parameter for default
Colour4The color for the fourth section, or -1 or an empty parameter for default
Colour5The color for the fifth section, or -1 or an empty parameter for default. Negative bar colors start from here
Colour6The color for the sixth section, or -1 or an empty parameter for default
Colour7The color for the seventh section, or -1 or an empty parameter for default
Colour8The color for the eighth section, or -1 or an empty parameter for default
IsStacked100%

For bars with multiple data points, defines whether the bar length should be the same for all charts, or whether the bar length should be proportional to the total for that bar:

  • 0 - Total bar width varies according to the total, with the longest bar width given by the LongestBarLength parameter
  • 1 – Bar widths are all equal, with the widths of individual data points showing their proportion of the total
ShowZerosSpecifies whether to draw bars for zero-valued data points
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
DataLabelAlign

Specifies the position of data labels for the bars:

  • 0 – No data label
  • 1 – Draw labels after the bars
  • 2 – Draa labels before the bars
DataLabelFontNameThe typeface to use for the data labels
DataLabelFontSizeThe font size for the data labels
DataLabelFormatStringThe format string for the data labels
DataLabelFontStyleReserved.
DataLabelColourThe colour for the data labels, or -1 or an empty parameter for none
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, labelled 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