SparkIcon Chart Designer

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.

	Triangle
	Rhomb
	Circle
	Circle20
	Circle40
	Circle60
	Circle80
	Circle100
	ArrowUp
	ArrowDown
	Square20
	Square40
	Square60
	Square80
	Square100
	Checkmark
	X
	Asterisks

See Also

• XL3SparkIcon formula