Pareto Sparklines

To create pareto sparklines in the workbook:

  1. Click Insert from the menu.

  2. Click Sparkline and select the pareto sparkline under Bar Sparkline from the list.

  3. In the Create Sparklines dialog box:

    1. Select a range of cells in the same row or the same column.

    2. Select the cell where the sparkline will appear.

    3. Click OK.

  4. The sparkline is displayed in the cell. You can now customize the sparkline by clicking Design from the menu and selecting Settings.

  5. Set the parameters as described below and click OK.

  6. Copy and paste the cell as needed to finalize your pareto sparklines.

Pareto sparkline parameter Description
Points Reference that represents the range of cells containing all the values, such as "A1:A4".
PointIndex Number or reference that represents the segment's index of the points; the PointIndex is >= 1, such as 1 or "D2".
ColorRange (Optional) Reference that represents the range of cells containing the color for the segment box, such as "D2:D7"; the default value is null.
HightlightPosition (Optional) Number or reference that represents the rank of the segment to be colored in red, such as 3; the default value is null.
Target (Optional) Number or reference that represents the "target" line position, such as 0.5; the default value is null.
Target2 (Optional) Number or reference that represents the "target2" line position, such as 0.5; the default value is null.
Label

(Optional) Number that represents whether the segment's label is displayed as:

  • the accumulated percentage (1),

  • the single percentage (2),

  • none (0) (default).
Vertical (Optional) Boolean that represents whether to display the sparkline vertically. The default value is false.

The pareto sparkline formula has the following format:

=PARETOSPARKLINE(points, pointIndex, colorRange, target, target2, hightlightPosition, lable, vertical, targetColor, target2Color, labelColor, barSize)
Additional formula parameters  
targetColor (Optional) String that represents the target line color.
target2Color (Optional) String that represents the second target line color.
labelColor (Optional) String that represents the label fore color.

barSize

 (Optional) Number that represents that the percentage of bar width/height according to the cell height/ width (value > 0 and value <= 1).