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
- Select the Pareto chart.
- To hide or show the cumulation line, in the Properties pane,
under Chart Annotations, set the Cumulation
Line property.
- To customize the cumulation line, click the 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.