SparkBox Chart Designer
This dialog is used to format any SparkBox In-Cell Chart in your report.
For details about how to invoke the dialog, see In-Cell Chart Designer.
Chart Options
- Length
- The horizontal scale factor to use when drawing the chart
- Use custom percentile boundries
- A set of values to define the percentile boundaries for the box plot, these are:
- the sample minimum (smallest observation)
- the lower quartile or first quartile
- the median (middle value)
- the upper quartile or third quartile
- the sample maximum (largest observation)
- Box Plot Anatomy
- Colour
- The following diagram shows the anatomy of the XL3SparkBox diagram. The letters refer to the names of the colour selecting boxes in the SparkBox In-Cell Chart Dialogue.
| A | Whisker |
| B | Bar |
| C | Box |
| D | Median |
| E | Border |
| F | MeanDot |
| G | UpperQuartile |
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
- A value to use for the minimum horizontal axis value
- Custom axis maximum
- A value to use for the maximum horizontal axis value
