It allows you to format any SparkBullet In-Cell Charts in your report. For details about how to invoke the dialog, see In-Cell Chart Designer.
Chart Options
This page has two modes. When the qualitative ranges are based on a range in your Workbook, some of the controls won't be editable or hidden. The values they contain will be set before you start working.
| Option | Description |
| Qualitative ranges | Specifies how many qualitative ranges should be rendered in the bullet chart. Available only when not being driven from a range. |
| Reverse range order | -1 to cause the qualitative ranges to be reversed when rendering. |
| Use Excel range | Specifies that values in the given range should define the qualitative ranges. |
| Show measure as | Specifies whether to render the measure value as a bar or a dot. |
| Measure bar color | The color to user for the measure bar or dot. |
| Bullet length | The width of the bullet chart. |
When Use Excel range is enabled
- Range color: The color for the given qualitative range.
When Use Excel range is disabled
- Lower limit: Gives the lower limit for the first qualitative range.
Subsequent rows give the color and upper limit for each qualitative range.
Reference Value Options
Reference lines
| Options | Description |
| No reference lines | The bullet chart is rendered without reference lines. |
| One reference line | The bullet chart has one reference line. |
| Two reference lines | The bullet chart has two reference lines. |
| Color | The color to use for the given reference line. |
| Value | The value to use for the given reference line. May be either a value or a range. |
Projection bar
| Option | Description |
| No projection bar | The bullet chart is rendered without a projection bar. |
| Projection bar | The bullet chart has an additional bar or dot, showing the projected value for the measure. |
| Color | The color to use for the projection bar. |
| Value | The value to use for the projection bar. May be either a value or a range. |
Axis Options
| Option | Description |
| 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 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. |
