Define the Cumulation Line in a Pareto Chart

The cumulation line on a Pareto chart displays the percentage of the accumulated total of all the columns or bars. For example, if your chart displays revenue by product line by year, the cumulation line at the second year's column would be the total revenue of the first and second years.

You can customize the appearance of the cumulation line and its data points.

Procedure

  1. Select the Pareto chart.
  2. To hide or show the cumulation line, in the Properties pane, under Chart Annotations, set the Cumulation Line property.
  3. To customize the cumulation line, click the cumulation line icon cumulation line icon, and in the Properties pane, under General, set the following properties:
    • Line Styles defines the cumulation line color, style, and weight.
    • Cumulation Label defines the label in the legend for the cumulation line. You can use the default label from the data source or type a custom label. The color and marker shape of the cumulation line still appears in the legend when this property is set to None.
    • Data Points defines whether to show or hide data points along the cumulation line, whether to show or hide data point borders, the color of data point borders, and the data point size and shape.
    • Data Labels specifies whether to show or hide the labels for the data points along the cumulation line.