# PARETOSPARKLINE

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## 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

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. |

## Data Types

Returns sparkline.

## Example

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