How does Excel make a two-tier pie chart? Excel making a double-layer pie chart tutorial

How does Excel make a double-layer pie chart? We all know that the pie chart reflects the proportional relationship of the part in the whole. It can be made according to your own needs during the use process. Sometimes, in order to more highlight the proportional relationship of the data, you need to make a double-layer pie chart, then how to make a double-layer cake What about the map?

Here is a detailed introduction to Excel making double-layer pie chart method:

Step

Start excel2003, open the prepared data, select cell b3, execute Insert the - function command, select the data area d3: d8 and click the OK button, the total number of people in the seventh grade is calculated, the same reason to calculate the number of eighth and ninth grade.

Select a3:b5 to the data area, execute the Insert-Graph command, select the pie chart in the pop-up Chart Wizard - Chart Properties, select the first one in the sub-chart type and click Next.

In step 2 of the chart wizard, in the pop-up dialog box, the data area refers to =Sheet1! $A$3: $B$5. Then click on the Series tab.

In the Series tab, click the Add button in the series to create a Series 2 in the series and select =Sheet1 in the value! $D$3: $D$20. Click Next.

In step 3 of the Chart Wizard, click on the Legend tab, in which the checkmark in the front square is “displayed.

Click the Data Flags tab, switch to the tab, select the category name, value and percentage options in the tab, then click the Finish button.

Drag and drop the surrounding square to adjust the size and position of the chart area. Right click on the chart and select the Data Series Format command from the drop-down menu. In the Data Series Format dialog box, click the axis on the tab. Select the secondary axis and click the OK button.

Right-click the chart and select the Data Source option from the drop-down menu. In the Data Source dialog box, click the Series tab, switch to the tab and select Series 2, click the button to the right of the sub-category flag, select the data. For area c3:c20, click the OK button.

Use the left mouse button to select the pie chart inside, change its size, and select the fan shape in the upper left corner to drag outward. At this time, you can see that the two series of charts are separated, and then select three fan shapes to drag inward. Hey.

Select one of the sectors, right click and select the data point format from the drop-down menu. In the pop-up dialog box, select the pattern option and select from the border. Define, click on the fill effect, click on the pattern in this option, set the foreground and background colors yourself, and click the OK button.

This double-layer chart is completed. Execute the file-save command and select a suitable location to save.