Comparison Chart Designer

There are two types of Comparison In-cell Charts that you can use within your report:

  • Indicator Comparison Chart:
This shows the current performance with an indicator icon for comparison to a defined baseline value (e.g. Budget, Forecast)
  • Integrated Variance Chart:
This is an overlay chart used to show current performance, with integrated variances to prior period

This dialog is used to format any Comparison In-Cell Charts in your report.

For details about how to invoke the dialog, see In-Cell Chart Designer.

Comparison Options

Chart Type
Choose between the following types of charts:
Integrated Variance:
Indictor Comparison:
Compare Values
The range of data to use for comparison.
The width of the chart
Positive Value
The default colour to use for positive values
Negative Value
The default colour to use for negative values
The default colour to use for an increase in value.
The default colour to use for a decrease in value.

Axis Options

Customise axis
Allows you to choose further options defining how the formula cell (for In-Cell Chart formulae), or the member name (when used in Grids) is rendered
Use title only
Uses the given text as a caption
Axis with tickmarks above
Draws a horizontal axis, with tickmarks and optional labels above the axis
Axis with tickmarks below
Draws a horizontal axis, with tickmarks and optional labels below the axis
Custom tickmark frequency
Overrides the automatic calculation of major tickmarks
Minor ticks per major tick
Adds the given number of minor (labelless) tickmarks between each major tickmark
Show labels on major ticks
Specifies whether numeric labels should be rendered for the axis
Number format
The format string to be used for the axis labels
Custom axis minimum
Overrides the automatic minimum for the axis
Custom axis maximum
Overrides the automatic maximum for the axis

See Also