PARETOSPARKLINE
The pareto sparkline has the following options:
| Option | Description |
| points | A reference that represents the range of cells that contains all values, such as "B2:B7". |
| pointIndex | A number or reference that represents the segment's index of the points, such as 1 or "D2". The pointIndex >= 1 . |
| colorRange | A reference that represents the range of cells that contain the color for the segment box, such as "D2:D7". This setting is optional. The default value is none. |
| target | A number or reference that represents the 'target' line position, such as 0.5. This setting is optional. The default value is none. The target line color is #8CBF64 if shown. |
| target2 | A number or reference that represents the 'target2' line position, such as 0.8. This setting is optional. The default value is none. The target2 line color is #EE5D5D if shown. |
| highlightPosition | A number or reference that represents the rank of the segment to be colored in red, such as 3. This setting is optional. The default value is none. If you set the highlightPosition to a value such as 4, then the fourth segment box's color is set to #CB0000. If you do not set the highlightPosition, the segment box's color is set to the color you assigned to the colorRange or the default color #969696. |
| label | A number that represents whether the segment's label is displayed as the cumulated percentage (label = 1) or the single percentage or none (label = 2) or none, such as 2,1. This setting is optional. The default value is 0. |
| vertical | A boolean that represents whether the box's direction is vertical or horizontal. This setting is optional. The default value is FALSE. |
Sample Usage
In order to use the PARETOSPARKLINE formula, start with your edited Excellentable:
Then type in the PARETOSPARKLINE formula in the area you would like to display the outcome:
By adding the values you would like to calculate the PARETOSPARKLINE formula for, Excellentable will generate the outcome:
A
|
B
|
C
|
|
|---|---|---|---|
1
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
D
|
|
|---|---|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
6
|
|
7
|
|
8
|
|
9
|