PARETOSPARKLINE

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.