# PARETOSPARKLINE

## Content

This function returns a data set used for representing a pareto sparkline.

## Syntax

`PARETOSPARKLINE(points, pointIndex, [colorRange, target, target2, hightlightPosition, label, vertical, targetColor, target2Color, labelColor, barSize])`

## 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.<br>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.<br>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.<br>If you set the highlightPosition to a value such as 4, then the fourth segment box's color is set to #CB0000.<br>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. |

## Data Types

Returns sparkline.

## Examples

```JavaScript
activeSheet.setFormula(1, 3, '=PARETOSPARKLINE(B2:B7,1,C2:C7,B8,B9,4,2,false,B10,B11,C2,1)');
```