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

    Sparkicon.png

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

    These charts have two ways of being used:

    • Single data source: the colour and icon type are driven from the same data, giving two ways to see the same information
    • Dual data sources: the colour and icon type have independent data sources, giving the opportunity to increase data density of your reports

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

    Single Data Source Mode

    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)
    Icon count
    Specifies how many icon styles to use
    Reverse range order
    -1 to cause the icon ranges to be reversed when rendering
    Icon type field
    The icon type to use for the given value range. See below for a list of icon types
    Colour field
    The colour to use for the given value range
    Operator and value fields
    Together, these give the boundaries for the given value range. The highest value range should be at the top
    Separate Icons and Colours
    Converts the SparkIcon Chart to a dual data source chart

    Dual Data Source Mode

    Icon Options

    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)
    Icon count
    Specifies how many icon types to use
    Reverse range order
    -1 to cause the icon ranges to be reversed when rendering
    Icon type field
    The icon type to use for the given value range. See below for a list of icon types
    Operator and value fields
    Together, these give the boundaries for the given value range. The highest value range should be at the top
    Merge Icons and Colours
    Converts the SparkIcon Chart to a single data source chart. Note that the colour boundaries are discarded when using this option

    Colour Options

    Colour data
    Specifies the data to use to render the icon colours
    Colour count
    Specifies how many colours to use
    Reverse range order
    -1 to cause the colour ranges to be reversed when rendering
    Colour field
    The colour to use for the given value range
    Operator and value fields
    Together, these give the boundaries for the given value range. The highest value range should be at the top

    Icon Sets

    The following icon types are available for use with In-Cell Charts.

    SparkIconTriangle.png
    Triangle
    SparkIconRhomb.png
    Rhomb
    SparkIconCircle.png
    Circle
    SparkIconCircle20.png
    Circle20
    SparkIconCircle40.png
    Circle40
    SparkIconCircle60.png
    Circle60
    SparkIconCircle80.png
    Circle80
    SparkIconCircle100.png
    Circle100
    SparkIconArrowUp.png
    ArrowUp
    SparkIconArrowDown.png
    ArrowDown
    SparkIconSquare20.png
    Square20
    SparkIconSquare40.png
    Square40
    SparkIconSquare60.png
    Square60
    SparkIconSquare80.png
    Square80
    SparkIconSquare100.png
    Square100
    SparkIconCheckmark.png
    Checkmark
    SparkIconX.png
    X
    SparkIconAsterisks.png
    Asterisks

    See Also