How to Make a Doughnut Chart in Excel (2 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

A doughnut chart is a type of chart that is available in Excel. A doughnut chart represents data as part of a whole relationship. The main focus of this article is to explain how to make a doughnut chart in Excel.


What Is a Doughnut Chart?

Doughnut charts represent the data in each cell as a slice of a doughnut. The chart may have one or more doughnuts stacked on top of each other. Doughnut charts allow you to display the relationship between different kinds of data. Each doughnut displays a set of data.


How to Make a Doughnut Chart In Excel: 2 Examples

In this article, I will explain 2 examples for you to understand clearly how to make a doughnut chart. Here, I have taken a dataset that contains sales information. It contains names of different Salesperson and Sales of different months. I will use this data set to explain how to make a doughnut chart in Excel


1. Making a Doughnut Chart in Excel with Single Data Series

In this example, I will show you how to make a doughnut chart in Excel with single data series. Here, I have taken a dataset that contains names of different Salesperson and Sales. I want to represent this data in a doughnut chart.

Making a Doughnut Chart in Excel with Single Data Series

Let’s see the steps of how to make a doughnut chart in Excel with single data series.


Step-01: Inserting Doughnut Chart

In this first step, I will insert the doughnut chart into the worksheet.

  • Firstly, select the dataset that you want to represent in your doughnut chart.
  • Secondly, go to the Insert tab.
  • Thirdly, select Insert Pie or Doughnut Chart from the Charts options.

A drop-down menu will open.

  • After that, select Doughnut Chart from the drop-down menu.

Making a Doughnut Chart in Excel with Single Data Series

Now, you will see that your doughnut chart has been inserted into your worksheet.


Step-02: Formatting Doughnut Chart

In this step, I will format the doughnut chart that I inserted.

  • To begin with, you can add a chart title. Here, added mine as Sales Overview.

Making a Doughnut Chart in Excel with Single Data Series

Now, you can add data labels to your doughnut chart.

  • Firstly, Right-click on the chart.
  • Secondly, select Add Data Labels.

You will see that data labels have been added to your chart. After that, you can select any other format you want for your doughnut chart.

  • Firstly, select the chart.
  • Secondly, go to Chart Styles.
  • Thirdly, select Style.
  • Finally, you can select any chart format from there. Here, I have selected the marked format in the image below but you can select any other format you like.

Now, you can also change the color of your doughnut chart.

  • Firstly, select the doughnut chart.
  • Secondly, go to Chart Styles.
  • Thirdly, select Color.
  • Finally,  select the color palette you like. Here, I selected the marked color Palette in the image.

After that, you can also change the doughnut thickness and other properties of the doughnut.

  • Firstly, select the doughnut chart.

Format Data Series will appear on the right side of the screen.

  • Secondly, change the Angle of first slice if you want. Here, I kept it 15 degrees.
  • Thirdly, change the Doughnut Hole Size to change the thickness of the doughnut chat. Here, I kept it at 40%.

Now, you can see that I have got my desired doughnut chart for single data series.

Making a Doughnut Chart in Excel with Single Data Series

Read More: How to Make Doughnut Chart with Total in Middle in Excel


2. Creating a Doughnut Chart in Excel with Multiple Data Series

In this example, I will show you how to make a doughnut chart in Excel with multiple data series. Here, I have taken a dataset that contains names of different Salesperson and Sales for March, April, and May. I will use this dataset to explain this example.

Let me show you the steps of making a doughnut chart in Excel with multiple data series.


Step-01: Inserting Doughnut Chart

In this step, I will insert a blank doughnut chart into my worksheet.

  • Firstly, go to the Insert tab.
  • Secondly, select Insert Pie or Doughnut Chart from the Charts options.

Creating a Doughnut Chart in Excel with Multiple Data Series

A drop-down menu will open.

  • Now, select Doughnut Chart from the drop-down menu.

Here, you will see that a blank doughnut chart has been inserted into your worksheet.

Creating a Doughnut Chart in Excel with Multiple Data Series

Read More: Excel Doughnut Chart with Multiple Rings


Step-02: Inserting Data into Doughnut Chart

In this step, I will insert data into the blank doughnut chart.

  • Firstly, select the chart.
  • Secondly, go to Chart Design.
  • Thirdly, select Select Data.

A dialog box named Select Data Source will appear on the screen.

  • Now, select Add to add your first data series.

Here, you will get a new dialog box named Edit Series to add your data to the chart.

  • Firstly, select the marked button to add the Series name.

Creating a Doughnut Chart in Excel with Multiple Data Series

  • Secondly, select the range for your Series name.
  • After that, click on the marked button to add this to your Edit Series.

You will see that your Series name is added to your Edit Series.

  • Now, select the marked button to add Series values.

  • After that, select the range for Series values.
  • Next, select the marked button to add the value to your Edit Series.

Creating a Doughnut Chart in Excel with Multiple Data Series

Now, you will see that both Series name and Series values are added to the Edit Series.

  • Finally, select OK.

  • After that select Edit to add the Horizontal (Category) Axis Labels.

  • Now, select your Axis label range.
  • Finally, select OK.

Now, we will add the second data series.

  • To begin with, select Add.

After that, the Edit Series dialog box will appear I will add the data following the process of Step-02 of Method-2.

  • Firstly, add the Series name.
  • Secondly, add the Series values.
  • Thirdly, select OK.

Creating a Doughnut Chart in Excel with Multiple Data Series

Now, data for the second data series has been added to the doughnut chart. Here, we will add the third data series.

  • To begin with, select Add.

After that, the Edit Series dialog box will appear. Now, I will add the data following the process in Step-02 of Method-2.

  • Firstly, add the Series name.
  • Secondly, add the Series values.
  • Thirdly, select OK.

Creating a Doughnut Chart in Excel with Multiple Data Series

Now, all the data series have been added to your chart.

  • Finally, select OK.

Here, you can see that I have got the doughnut chart for multiple data series.

Creating a Doughnut Chart in Excel with Multiple Data Series


Step-03: Formatting Doughnut Chart

In this step, I will format the chart to get our final doughnut chart.

To begin with, you can add different elements to your chart.

  • Firstly, select the chart.
  • Secondly, select the elements you want from Chart Elements. Here, I selected Chart Title and Data Labels.

Creating a Doughnut Chart in Excel with Multiple Data Series

  • After that, you can add Chart Title as you want for your doughnut chart.

Now, you can change the thickness of your doughnut chart.

  • Firstly, select the doughnut chart.

Format Data Series will appear on the right side of the screen.

  • Secondly, change the Angle of first slice if you want. Here, I kept it 10 degrees.
  • Thirdly, change the Doughnut Hole Size to change the thickness of the doughnut chat. Here, I kept it at 35%.

Creating a Doughnut Chart in Excel with Multiple Data Series

Here, you can change the format for your doughnut chart.

  • Firstly, select the chart.
  • Secondly, go to Chart Styles.
  • Thirdly, select Style.
  • Finally, you can select any chart format from there. Here, I have selected the marked format in the image below but you can select any other format you like.

Now, you can also change the colors of your doughnut chart.

  • Firstly, select the doughnut chart.
  • Secondly, go to Chart Styles.
  • Thirdly, select Color.
  • Finally,  select the color palette you like. Here, I selected the marked color Palette in the image. But, you can select any other color.

Creating a Doughnut Chart in Excel with Multiple Data Series

Here, I will make an exploded doughnut chart.

  • Firstly, select the outer series of the doughnut chart.
  • Secondly, change Doughnut Explosion to get your desired exploded doughnut chart. Here, I kept it at 20%.

Creating a Doughnut Chart in Excel with Multiple Data Series

Now, you can see that I have got my desired exploded doughnut chart for multiple data series.

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


Practice Section

Here, I have provided a practice sheet for you to practice how to make a doughnut chart in Excel.

How to Make a Doughnut Chart in Excel


Download Practice Workbook


Conclusion

To conclude, I tried to explain 2 examples of how to make a doughnut chart in Excel. I covered the process for both single and multiple data series. I hope this article was helpful for you. To get more articles like this visit ExcelDemy. If you have any questions, feel free to let me know in the comment section below.


Related Articles


<< Go Back to Excel Doughnut Chart | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo