Practical Excel skills sharing: the use of double-layer pie charts

Speaking of making column charts, bar charts, and pie charts, I believe everyone has no problem. Just select the data and insert the corresponding chart. But if you want to make a two-layer pie chart, would you still do it? "What? There is also a double-layered pie chart?" Hey, I don't know. Compared with ordinary pie charts, a double-layered pie chart has a clearer structure and can display a variety of data more intuitively. Hurry up and follow the editor to take a look~

Please use the Excel 2013 or 2016 version to be consistent with the tutorial and easy to learn.

Xiao Zhang is a fresh graduate who has just arrived at the company. He works as a data entry clerk in the company's sales department. His main job is to maintain and initially organize and analyze sales data. Newcomers who have just entered the society are full of passion for work. No, the department boss has spoken in the work group to sort out the company's sales revenue data for each month of 2018.

Xiao Zhang, who was full of enthusiasm, happily accepted this task, organized the data in Excel, and then directly made the graph below, and prepared to present the report to the department boss. But if you think about it carefully, wouldn’t it be better if you could show monthly sales revenue, quarterly sales revenue, and the proportion of sales revenue in each month?

In order to better present the data, Xiao Zhang is going to use another charting idea to make charts. The final effect is as shown in the picture below. Friends who want to learn Just follow Xiaobai’s ideas and make pictures.

Chart making ideas:

Prepare charting data based on source data - first add monthly sales revenue data and set up the pie chart Fill it with color, then add the quarterly data, set it as the secondary axis, and change its horizontal axis label. Then set its pie chart separation to 80%, and then double-click the pie chart to set its point separation to 0%. Set the fill color and beautify the chart to complete the entire production process.

Drawing process:

Step 01 Prepare drawing data

Enter the source data in Excel and organize the source data according to the drawing ideas. The operation is as shown in the figure below.

Step 02 Set monthly data

① Select the monthly sales data area F2:G14, go to the "Insert" tab - insert chart - "pie chart", then click "OK" to generate the chart, the operation is as follows shown.

② Set the position of chart elements and delete unnecessary elements in the chart. Click the legend in the chart and press the delete key to delete it. The operation is as shown in the figure below.

#③ Set the fill color for the pie pieces in sequence according to the RGB provided in the table. Click on the pie piece, go to the "Format" tab - "Shape Fill", select "Other Color Fill". The operation is shown in the figure below.

Step 03 Add quarterly data

① Click on the pie chart, go to the "Design" tab - "Select Data", add the quarterly data, and click Confirm. The operation is shown in the figure below.

Change the quarterly data horizontal data axis label and set the pie chart fill color in sequence. The operation steps are as shown in the figure below.

② Right-click the pie chart, select "Change Series Chart Type", and draw the quarterly pie chart on the "secondary axis". The operation is as shown in the figure below.

Step 04 Adjust the pie chart

① Click on the quarterly pie chart, set the pie chart separation to 80%, then double-click a single pie block, and set its point separation to 0% in turn. The operation steps are as shown in the figure below .

② Add data labels, check "Category Name" in "Label Options", and set the separator below to "(New Text Line)". The font color of the data label is white, and its operation is as shown in the figure below.

Step 05 Beautify the chart

① Add a title to the chart, the font is Microsoft Yahei, the font size is 12, and bold. Insert a text box and add a secondary title. The font is Microsoft Yahei and the font size is 11. The effect is as shown in the figure below.

② In the "Insert" tab, select to insert a circle, copy and paste it into the chart. Finally, add color blocks and data source descriptions to the chart to complete the entire chart.

If you want to display the sales revenue ratio for each quarter and each month, you can change the value to 100% in the setting data label. The operation effect is as follows .

Okay, that’s it for today’s explanation. The best way to master charts is to try it again. If you still have questions during the practice, you can take a look. The video below, so you don’t have to worry about not being able to learn.

OK, have you learned today’s double-layered pie chart?

Related learning recommendations: excel tutorial

The above is the detailed content of Practical Excel skills sharing: the use of double-layer pie charts. For more information, please follow other related articles on the PHP Chinese website!