How to make a complete set of product production analysis table with excel

The final effect of data collection, data entry and table setting is shown in the figure (for beginners, the header is the most easily overlooked in the process of making tables).

As shown in the figure, select the data range to analyze. (For beginners, it is easiest to select the whole table when selecting a fixed range. )

As shown in the figure, click Insert on the menu bar, select Pie Chart, and then select 3D Pie Chart. In practical work, you can choose the corresponding graphic effect according to your own analysis.

The final generated effect is shown in the following figure 1. Next, select the "Chart Layout" marked with a red box and find the percentage, as shown in Figure 2 below.

Finally, modify the "Chart Title", put the mouse on the "Chart Title", click the left mouse button, and enter the title name consistent with the table. (For beginners, this step is also the easiest to ignore. The final effect is shown in the figure below.