Plato needs to create an auxiliary column to display the cumulative proportional data, use formulas, insert cluster column charts, select charts, and add chart elements in the design to make the coordinate axis a secondary axis. The specific operation steps are as follows.

1. First, you need to create an auxiliary column to display the cumulative proportion data and use the formula. As shown in the figure below:

2. Drop down the filling formula to create an auxiliary column, as shown in the figure below.

3. Select items and data columns, and click Insert Cluster Column Chart, as shown in the figure below.

4. Then select and copy the created auxiliary column. After selecting a column chart, press CTRL+V to paste the data into the chart, as shown in the following figure.

5. Then right-click the column chart generated by the auxiliary column data, select Change Series Chart Type, select the bar chart with data label, and check the secondary axis, as shown in the figure below.

6. Select a chart and click 【 Add chart elements, axes and secondary axes in the design 】, as shown in the following figure.

7. Then select the newly added secondary abscissa axis, right-click, select the format axis, and select the scale line under the axis, as shown in the figure below.

8. Then click the label below, find "Label Location" and select "None", as shown below.

9. Finally, beautify the chart a little, and get the final Plato as shown in the figure below.

Precautions:

Pareto chart, usually called Plato, is one of the important tools of quality management. Users can complete the production according to the above steps.