SparkBar Chart Designer
This dialog 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
- Colours 1 to 8
- Specify the colours used for the bars. If the bar is positive, the data points will start with colour 1; if the bar is negative, the data points will start with colour 5.
- Stacked bar chart
- The total bar width varies according to the total
- 100% stacked bar chart
- The widths are all equal, with the widths of individual data points showing their proportion of the total
- Custom bar length
- Specifies the maximum chart width
- Show zero bars
- Specifies whether to draw bars for zero-valued data points
Value Label Options
- Use value labels
- If selected, each bar is labelled with its total value
- Before bar
- The value label is rendered to the left of the chart itself
- After bar
- The value label is rendered to the right of the chart itself
- Number format
- Specifies the format string for the value labels
- Label colour
- The colour for the value labels
- Font
- Allows you to choose the typeface and size of the value labels
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
- XL3SparkBar formula
- XL3SparkBarM formula
