Difference between revisions of "SparkBar Chart Designer"
(Created page with '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== ; Colour…') |
(Added See Also section (formula reference)) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Image:sparkbar.png|350px]] | ||
| + | |||
This dialog is used to format any SparkBar In-Cell Charts in your report. | This dialog is used to format any SparkBar In-Cell Charts in your report. | ||
| Line 50: | Line 52: | ||
; Custom axis maximum | ; Custom axis maximum | ||
: Overrides the automatic maximum for the axis | : Overrides the automatic maximum for the axis | ||
| + | |||
| + | ==See Also== | ||
| + | * [[XL3SparkBar]] formula | ||
| + | * [[XL3SparkBarM]] formula | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
| + | [[Category:In-Cell Chart Designers]] | ||
Latest revision as of 10:45, 5 June 2015
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
