Use WPS table to make Pareto chart

Source: Internet
Author: User

Introduction of Pareto chart

Pareto graph (Pareto Chart), also known as Plato, the ranking of primary and secondary factors, is one of the seven methods of quality management. This name is called because it is conceptually related to Paretofa (Pareto principle). In quality management, most of the losses are caused by a few critical quality problems that are often caused by a few key defects. By using Pareto graph, the main factors that affect the quality problem can be visualized, which makes it easier to improve the quality problem.

The Pareto diagram contains a column chart and a line chart with about two ordinate, and a horizontal coordinate. The left longitudinal axis indicates the frequency of defect causes, the vertical axis of the right indicates the cumulative frequency of defect causes, and the horizontal axis represents the factors affecting the quality, which are arranged from left to right, according to their impact size. The height of the straight square column indicates the influence of the factor, and the polyline represents the connection of the cumulative frequency.

Second, Pareto drawing production:

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

Third, the chart beautification

The rest is some landscaping work:

1, set the secondary axis scale:

On the Chart Tools tab, select Secondary axis in the Drop-down list, and then click Format Selection. Click the Tick tab in the pop-up window to set the minimum value to 0, the maximum setting to 1.1, and the other unchanged. Then click the "OK" button.


2, according to the data color separation:

You can also set each column to appear in a different color if you want. On the Chart Tools tab, in the Drop-down list, select series ' Frequency ', and then click ' Format Selection '. Click the "Options" tab in the pop-up window, tick "color separations" and click OK.


3, the plot area, the main grid line, line, font and other aspects of beautification:

You can also format other parts of the chart according to your preferences. I set the border of the plot area to none and the color of the main gridlines for the value axis to white. Sets the color of the series cumulative percent to a custom red and sets the font for category axis, value axis, value axis, and legend to Microsoft Ya-black. The final effect is shown below:

Form making

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.