WPS table How to make Pareto chart

The method of making Pareto graph by WPS table

Let's say we've created a list of the following product defect reason times in the WPS table.

Here we make a Pareto graph based on these data. First of all, the result of the final accomplishment:

Specific steps:

1, select cell B4:f11, click "Insert → chart", "Chart type" select "Column Chart", then click "Next".

2, click the "Series" tab, delete "cumulative frequency" and "percentage" two series. Then click "Finish".

At this point the chart looks like this:

3, select the chart, click the "Chart Tools" tab, in the Drop-down list select "series ' Cumulative Percentage '" Click "Change Chart Type". In the Chart type window that pops up, select the first chart (data point line chart) in the second row under Line chart, and click OK.

4, click the "Set Selection Format" button, in the pop-up window click the "Axis" tab, in the "series drawn in" group, select the secondary axis.

5, click on the "Data Labels" tab, in the "data label includes" group, check "value". Then in the label location, select Top.

At this point, the Pareto diagram has been basically drawn complete