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


    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.


    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


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


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

    See Also