Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • SparkBar Chart Designer

    Sparkbar.png

    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