How to Make a Multi-Level Pie Chart in Excel (with Easy Steps)

A multi-level pie chart is an efficient tool for visualizing and comparing data with each other at different levels. If you are curious to learn about this type of chart, this article may come in handy for you. In this article, we are going to show how you can make a multi-level pie chart in Excel with elaborate explanations.


Step-by-Step Procedure to Make a Multi-Level Pie Chart in Excel

In the below article, we made a multilevel pie chart in Excel with step-by-step explanations. Not only that, we also formatted the style of the chart to make it more understandable.


Step 1: Prepare Dataset

Before we delve into creating the pie chart, we need to collect and organize the information that we are going to plot in the chart. Here we have information about the student’s marks in different subjects. This information is going to be plotted in different layers where each layer denotes each subject.

Prepare Dataset to Make a Multi-Level Pie Chart in Excel


Step 2: Create Doughnut Chart

After we have collected and organized the information, we can create a pie chart.

  • To begin with, we need to select the dataset, and then from the Insert tab, click on the Insert Pie or Doughnut Chart. Then from the dropdown menu, click on the Doughnut chart option.

Create Primary Multi-level Pie Chart to Make a Multi-Level Pie Chart in Excel

  • Right after clicking the Doughnut chart option, you will notice that there is a doughnut chart with multiple layers presented now.
  • This chart needs some modifications as it is too vague to understand appropriately right now. 

Read More: How to Make Multiple Pie Charts from One Table


Step 3: Place Legends on Right Side

In the beginning, we need to put the legends on the right side of the chart. Right now, the legends are set at the bottom of the chart plot area, which is not a very suitable place.

Place Legends on Right Side to Make a Multi-Level Pie Chart in Excel

  • Click on the Plus Icon on the right side of the chart.
  • And from there, click on Legend > Right.
  • After this, the legends will shift to the right side of the chart. 

Place Legends on Right Side to Make a Multi-Level Pie Chart in Excel

Read More: How to Make Pie of Pie Chart in Excel


Step 4: Set Doughnut Hole Size to Zero

To modify the chart further, we first reduce the chart’s circle size to zero, in that way the doughnut chart would convert to a Pie chart.

  • Select the innermost circle of the chart, and right-click on it.
  • Then from the context menu, click on the Format Data Series.

Turn Doughnut Hole Size to Zero to Make a Multi-Level Pie Chart in Excel

  • Then on the side panel named the Format Data Series, go to the Series Options.
  • Then from the Series Options, notice the Doughnut Hole Size.
  • The Doughnut Hole Size is now set to 75%.
  • We need to make it to 0%.

Turn Doughnut Hole Size to Zero to Make a Multi-Level Pie Chart in Excel

  • Drag the slide until the percentage is shown as 0 percent or select the box and type 0%.
  • Right after setting the Percentage to 0, the doughnut chart middle circle will be zero.
  • And the doughnut will start looking like a pie chart with multiple layers.
  • Where the middle layer now shows the number distribution of students in the Math subject.
  • And middle layer shows the number distribution of students in English subjects.
  • And the outer layer shows the number distribution of students in the Social Science subject.
  • But it still missing the data labels.

Read More: How to Create a 3D Pie Chart in Excel


Step 5: Add Data Labels and Format Them

Adding data labels can help us analyze the information precisely.

  • Right-click on the outermost level on the chart and then right-click on the chart.
  • Then from the context menu, click on the Add Data Labels.
  • After clicking on the Add Data Labels, the data labels will show accordingly.

  • Right-click on the middle level on the chart and then right-click on the chart.
  • Then from the context menu, click on the Add Data Labels.
  • After clicking on the Add Data Labels, the data labels will show accordingly.

Add Data Label and Format to Make a Multi-Level Pie Chart in Excel

  • Right-click on the central level on the chart and then right-click on the chart.
  • Then from the context menu, click on the Add Data Labels.
  • After clicking on the Add Data Labels, the data labels will show accordingly.

  • After adding all the data labels and setting the chart title, the chart will look like this.

  • But still, the fonts are not looking as clear as they are supposed to be.
  • To make them visible and clear enough, select the data labels of the first row and right-click on them.
  • Then in the context menu, click on the Font.

  • In the Font dialog box, click on the Font style box and set the Font style to Bold.
  • And set the Font Size to 11.
  • Click OK after this.

  • Again select the outermost levels data label and right-click on it. Then from the context menu, click on the Change Data Label Shapes.
  • Then from the shapes select the Rectangular with a Rounded Corner.

Add Data Label and Format to Make a Multi-Level Pie Chart in Excel

  • After selecting the shape, you will notice that there is a shape with white filler.

  • Repeat the same process for the rest of the data labels.
  • The chart will look like this.

Add Data Label and Format to Make a Multi-Level Pie Chart in Excel

Read More: How to Make a Gender Pie Chart in Excel


Step 6: Finalize Multi-Level Pie Chart

To easily identify which data level belongs to which subject, we can add text boxes.

  • From the Insert tab, click on the Shapes, then from the dropdown menu.

  • Then draw the text boxes on the chart area.
  • In the text box, enter the name of the lowest level of the chart, which is the Math Subject.
  • Then add an arrow line and connect it with the text box and the Math circle level.

  • Repeat the same process for the rest of the layers.
  • The final output will look something like the below image.

Read More: How to Create & Customize Bar of Pie Chart in Excel


💬 Things to Remember

✐ The order of the chart levels depends on the table header serial. Place them accordingly.

✐ Resizing or moving the charts can make the text boxes move away and misplace them. So, add text boxes as the final steps.


Download Practice Workbook


Conclusion

Here, we made a multi-level pie chart in Excel with detailed explanations in step-by-step instructions.

For this problem, a workbook is available for download where you can practice these methods.

Feel free to ask any questions or feedback through the comment section. Any suggestion for the betterment of the Exceldemy community will be highly appreciable.


Related Articles


<< Go Back To Make a Pie Chart in Excel | Excel Pie ChartExcel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo