This feature is used to format any SparkBar In-Cell Charts in your report. For details about how to invoke the dialog, see In-Cell Chart Designer.

Chart options

The available color options include:

Color optionDescription
Colours 1 to 8

Specify the colors used for the bars.

  • If the bar is positive, the data points will start with color 1.
  • If the bar is negative, the data points will start with color 5.
Stacked bar chartThe total bar width varies according to the total.
100% stacked bar chartThe widths are all equal, with the widths of individual data points showing their proportion to the total.
Custom bar lengthSpecifies the maximum chart width.
Show zero barsSpecifies whether to draw bars for zero-valued data points.

Value label options

The available value label options include:

Value label optionDescription
Use value labelsIf selected, each bar is labeled with its total value.
Before barThe value label is rendered to the left of the chart itself.
After barThe value label is rendered to the right of the chart itself.
Number formatSpecifies the format string for the value labels.
Label colorThe color for the value labels.
FontAllows you to choose the typeface and size of the value labels

Axis options

The available axis options include:

Axis optionDescription

Customize axis


Allows you to choose further options defining how the formula cell (for In-Cell Chart formulas), or the member name (when used in Grids) is rendered.
Use title onlyUses the given text as a caption.
Axis with tickmarks aboveDraws a horizontal axis, with tickmarks and optional labels above the axis.
Axis with tickmarks belowDraws a horizontal axis, with tickmarks and optional labels below the axis.
Custom tickmark frequencyOverrides the automatic calculation of major tickmarks.
Minor ticks per major tickAdds the given number of minor (labelless) tickmarks between each major tickmark.
Show labels on major ticksSpecifies whether numeric labels should be rendered for the axis.
Number formatThe format string to be used for the axis labels.
Custom axis minimumOverrides the automatic minimum for the axis.
Custom axis maximumOverrides the automatic maximum for the axis.