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

    Sparkhorizon.png

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

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

    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)
    Positive colours
    The colours to use for the positive regions, highest at the bottom
    Negative colours
    The colours to use for the negative regions, most negative at the bottom
    Stretch factor
    The horizontal scale factor to use when drawing the chart
    Flip negative data
    When selected, negative values stretch down from the top rather than from the bottom:
    Normal XL3SparkHorizon NegativeNormal.png
    Flipped XL3SparkHorizon NegativeFlipped.png

    Missing values

    Don't plot missing values
    Leave a gap where there is a gap in the source data
    Plot missing values as zero
    Substitute gaps in the source data with zeros
    Interpolate missing values
    Fill in missing values with statistically appropriate values

    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

    See Also