Difference between revisions of "XL3SparkIcon"

m (Wrapped the -1s in Code tags)
(Added links to chart designer; moved icon sets to transcluded page for common reference)
Line 1: Line 1:
 
Creates an indicator icon that is rendered in an Excel cell.
 
Creates an indicator icon that is rendered in an Excel cell.
 +
 +
Double-clicking the chart, or selecting the {{Menu|XLCubed|Format In-Cell Chart...}} right-click menu item allow the editing of the chart format using the [[SparkIcon Chart Designer]].
  
 
==Syntax==
 
==Syntax==
Line 91: Line 93:
  
 
==Icon Sets==
 
==Icon Sets==
−
{| class="wikitable"
+
{{:SparkIcon Chart Icon Sets}}
−
| [[File:SparkIconTriangle.png|center]] || {{Code|Triangle}}
 
−
|-
 
−
| [[File:SparkIconRhomb.png|center]] || {{Code|Rhomb}}
 
−
|-
 
−
| [[File:SparkIconCircle.png|center]] || {{Code|Circle}}
 
−
|-
 
−
| [[File:SparkIconCircle20.png|center]] || {{Code|Circle20}}
 
−
|-
 
−
| [[File:SparkIconCircle40.png|center]] || {{Code|Circle40}}
 
−
|-
 
−
| [[File:SparkIconCircle60.png|center]] || {{Code|Circle60}}
 
−
|-
 
−
| [[File:SparkIconCircle80.png|center]] || {{Code|Circle80}}
 
−
|-
 
−
| [[File:SparkIconCircle100.png|center]] || {{Code|Circle100}}
 
−
|-
 
−
| [[File:SparkIconArrowUp.png|center]] || {{Code|ArrowUp}}
 
−
|-
 
−
| [[File:SparkIconArrowDown.png|center]] || {{Code|ArrowDown}}
 
−
|-
 
−
| [[File:SparkIconSquare20.png|center]] || {{Code|Square20}}
 
−
|-
 
−
| [[File:SparkIconSquare40.png|center]] || {{Code|Square40}}
 
−
|-
 
−
| [[File:SparkIconSquare60.png|center]] || {{Code|Square60}}
 
−
|-
 
−
| [[File:SparkIconSquare80.png|center]] || {{Code|Square80}}
 
−
|-
 
−
| [[File:SparkIconSquare100.png|center]] || {{Code|Square100}}
 
−
|-
 
−
| [[File:SparkIconCheckmark.png|center]] || {{Code|Checkmark}}
 
−
|-
 
−
| [[File:SparkIconX.png|center]] || {{Code|X}}
 
−
|-
 
−
| [[File:SparkIconAsterisks.png|center]] || {{Code|Asterisks}}
 
−
|}
 
  
 
==See Also==
 
==See Also==
 
* [[Formula Reference]]
 
* [[Formula Reference]]
 +
* [[SparkIcon Chart Designer]]
  
 
[[Category:Formulae]]
 
[[Category:Formulae]]
 
[[Category:In-Cell Chart Formulae]]
 
[[Category:In-Cell Chart Formulae]]
 
[[Category:In-Cell Charts]]
 
[[Category:In-Cell Charts]]

Revision as of 15:37, 2 December 2010

Creates an indicator icon that is rendered in an Excel cell.

Double-clicking the chart, or selecting the XLCubed > Format In-Cell Chart... right-click menu item allow the editing of the chart format using the SparkIcon Chart Designer.

Syntax

XL3SparkIcon( Data, Output, InRows, [IconSet], [Operators], [RangeCount], [Border1], [Border2], [Border3], [Border4], [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [RangeOrder], [AltData], [AltOperators], [AltRangeCount], [AltBorder1], [AltBorder2], [AltBorder3], [AltBorder4], [AltRangeOrder], [Label] )

Parameters

Parameter Description
Data The data to chart. This can be a range or a formula
Output The target range in which to render the chart(s)
InRows Specifies whether the input data are in rows or columns:
0 Data are in rows
1 Data are in columns
IconSet A pipe (|) delimited list of icons to use. The possible icons are listed below
Operators A pipe (|) delimited list operators to use. The possible values are > and >=
RangeCount The number of icon ranges to use
Border1 The value above which the first icon should be used
Border2 The value above which the second icon should be used
Border3 The value above which the third icon should be used
Border4 The value above which the fourth icon should be used. Values below this value will use the last icon
Colour1 The colour for the first range
Colour2 The colour for the second range
Colour3 The colour for the third range
Colour4 The colour for the fourth range
Colour5 The colour for the fifth range
RangeOrder -1 to reverse the icon order
AltData If specified, causes the colours to be driven from this instead of the Data parameter. This can be a range or a formula
AltOperators If AltData is specified, a pipe (|) delimited list operators to use for the colour ranges
AltRangeCount If AltData is specified, the number of colour ranges to use
AltBorder1 If AltData is specified, the value above which the first colour should be used
AltBorder2 If AltData is specified, the value above which the second colour should be used
AltBorder3 If AltData is specified, the value above which the third colour should be used
AltBorder4 If AltData is specified, the value above which the fourth colour should be used
AltRangeOrder If AltData is specified, -1 to reverse the colour order
Label Specifies the text to use in the formula cell

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

Retrieved from ‘https://help.fluencexl.com/index.php?title=XL3SparkIcon&oldid=3655’