Excel Doughnut Chart with Multiple Rings (Create with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

This article deals with the excel doughnut chart with multiple rings. A doughnut chart represents the relation of parts to a whole. It can contain multiple data series, and a different doughnut ring represents each data series. The inner-most ring always means the first data series.


Download Practice Workbook

You can download the following practice workbook by clicking on the download button.


What Is a Doughnut Chart?

A doughnut chart represents the relation of parts to a whole. It can contain multiple data series. A different doughnut ring represents each data series. The inner-most ring always means the first data series. Although a doughnut chart can plot multiple data series, it has some limitations. You should avoid using this chart if your dataset has negative values or zeros. Furthermore, you shouldn’t use it if each data series contains more than seven categories.

excel doughnut chart with multiple rings


Steps to Create a Doughnut Chart with Multiple Rings in Excel

Follow the steps below to create the doughnut chart with multiple rings.

πŸ“Œ Step 1: Organize Data

  • Assume that you have the following dataset. It contains the quarterly growth of different stores.


πŸ“Œ Step 2: Insert Doughnut Chart

  • After that, a doughnut chart with multiple rigs will be inserted. Here each ring represents a particular store. The inner-most ring always indicates the first store in the dataset.
  • You can click on the Chart Title to rename it as required.

excel doughnut chart with multiple rings

Read More: How to Create A Doughnut, Bubble and Pie of Pie Chart in Excel


πŸ“Œ Step 3: Increase Ring Size

  • Next, right-click on any doughnut rings and select Format Data Series.

  • After that, you will see the following result.

excel doughnut chart with multiple rings


πŸ“Œ Step 4: Change Outline

  • Now right-click on a doughnut ring and choose the desired outline. Do this for all of the rings.

  • After doing so, you will get the following result.

excel doughnut chart with multiple rings


πŸ“Œ Step 5: Add Data Labels

  • Next, click on the doughnut chart to access the Chart Element menu. Then check the Data Labels checkbox to show the data labels.

excel doughnut chart with multiple rings

Read More: How to Create Curved Labels in Excel Doughnut Chart (With Easy Steps)


πŸ“Œ Step 6: Switch Row/Column

  • Now you need to switch the rows and columns to show the growth in each quarter by each doughnut ring.
  • Right-click on a doughnut ring and click on Select Data to do that.

  • Then select Switch Row/Column and click OK.

  • After that, you will get the following result.

excel doughnut chart with multiple rings


πŸ“Œ Step 7: Change Color & Styles

  • Now click on the doughnut chart to access the Chart Design tab. Then select Change Colors and pick the desired color.

  • Alternatively, you can change the color of each slice manually. For that, click twice on a doughnut slice to select it. Then right-click to choose the fill color. Do this for all similar slices.

  • You can also pick a different chart style form there.

Read More: How to Change Color Based on Value in Excel Doughnut Chart


πŸ“Œ Step 8: Add Ring Indicator

  • You must’ve noticed that there is no legend indicating which doughnut ring represents what. Now click on the chart to access the Format tab. Then insert text boxes and arrows to describe the doughnut rings.

  • Finally, you will get the following result.

excel doughnut chart with multiple rings


Things to Remember

  • You must select the doughnut chart to access the editing tools.
  • It would be best if you had a dataset with multiple rows and columns to create a doughnut chart with multiple rings.

Conclusion

Now you know how to create an excel doughnut chart with multiple rings. Do you have any further queries or suggestions? If so,please let us know using the comment section below.

You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo