This function returns a data set used for representing a pareto sparkline.
PARETOSPARKLINE(points, pointIndex, [colorRange, target, target2, hightlightPosition, label, vertical, targetColor, target2Color, labelColor, barSize])
This function has the following arguments:
| Argument | 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 is >= 1. |
| colorRange |
(Optional) A reference that represents the range of cells that contain the color for the segment box, such as "D2:D7". The default value is none. |
| target |
(Optional) A number or reference that represents the 'target' line position, such as 0.5. The default value is none. The target line color is #8CBF64 if shown. |
| target2 |
(Optional) A number or reference that represents the 'target2' line position, such as 0.8. The default value is none. The target2 line color is #EE5D5D if shown. |
| highlightPosition |
(Optional) A number or reference that represents the rank of the segment to be colored in red, such as 3. 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 | (Optional) 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. The default value is 0. |
| vertical |
(Optional) A boolean that represents whether the box's direction is vertical. The default value is false. |
| targetColor |
(Optional) A color string that indicates the color of the target line. |
| target2Color |
(Optional) A color string that indicates the color of the target2 line. |
| labelColor |
(Optional) A color string that indicates the label fore color. |
| barSize |
(Optional) A number value greater than 0 and less than or equal to 1, which indicates the percentage of bar width or height according to the cell width or height. |
Returns sparkline.
activeSheet.setFormula(1, 3, '=PARETOSPARKLINE(B2:B7,1,C2:C7,B8,B9,4,2,false,B10,B11,C2,1)');