How to quickly create a double-layered pie chart in Excel Excel quick tutorial to create a double-layered pie chart

Do you want to know how to quickly create an Excel two-layer pie chart? Excel is an essential software for our daily work. In order to make tabular data more intuitive, many users want to create a two-layer pie chart, but may not know how to do it. PHP editor Baicao provides you with a step-by-step guide to help you easily create a two-layer pie chart. This tutorial will walk you through the process in detail, from data preparation to chart creation, ensuring you can easily master this skill. Through this tutorial, you will learn how to effectively visualize data, thereby improving work efficiency and presentation effects.

1. Select the cell range A2:B10, select the pie chart in the Insert tab and click OK to generate the chart. Change the horizontal data axis label of the regional data to cells C3:C10. The operation is as shown in the figure below.

2. Set the position of chart elements and delete unnecessary elements in the chart. Click on the legend in the chart and press delete to delete it.

3. Click on the pie chart, select data on the design tab, add regional data, change the regional data horizontal data axis label, click OK, the operation is as shown below Show.

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

5. Click on the area pie chart and set the pie chart separation to 80%, then double-click a single pie block and set its point separation to 0% in turn. The steps are as follows As shown in the figure.

6. Add a data label under the chart element, check the category name in the label option, and set the separator below to a line break. Its operation is shown in the figure below.

7. Beautify the chart, add a title to the chart, and select the appropriate style under the design bar of the chart tool. The effect is as shown in the figure below.

The above is the detailed content of How to quickly create a double-layered pie chart in Excel Excel quick tutorial to create a double-layered pie chart. For more information, please follow other related articles on the PHP Chinese website!