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

    Sparkcolumns.png

    This dialog is used to format any SparkColumns In-Cell Charts in your report.

    For details about how to invoke the dialog, see In-Cell Chart Designer.

    Chart Options

    General

    Title
    Specifies a title to place in the formula cell (for In-Cell Chart formulae), or to use as the member name (when used in Grids)
    Column colour
    The default colour to use for the columns
    Negative point colour
    The default colour to use for negative columns
    Column width
    The width of each column

    Column highlighting

    Minimum value colour
    The colour to highlight the lowest column
    Maximum value colour
    The colour to highlight the highest column
    Start value colour
    The colour to highlight the first column
    End value colour
    The colour to highlight the last column

    Axis Options

    Vertical Scale

    Automatic common scale
    If selected, overrides all the other vertical scale options and chooses one set of scales to suit all the charts controlled by this formula or member

    Minimum

    Automatic
    Selects a suitable minimum for each chart individually
    Custom
    Specifies the minimum for all charts

    Maximum

    Automatic
    Selects a suitable maximum for each chart individually
    Custom
    Specifies the maximum for all charts

    Period

    No period colour
    Disables alternate column shading
    Period colour
    Enables alternate column shading, allowing you to specify the alternate colour for positive and negative columns, and the length of the period

    Reference Line Options

    No reference line
    Disables the reference line
    Reference line
    Renders a reference line on each chart, and allows you to specify further options
    Reference line colour
    The colour for the reference line
    Automatic average
    Specifies that the reference line should be calculated as the mean of all the values in the chart
    Custom value
    Allows selection of a custom value or values for the reference line data points

    See Also