Excel Doughnut Chart

Here’s an example of a donut chart with multiple rings.

Excel Doughnut Chart


Download the Practice Workbook


What Exactly Is a Doughnut Chart?

Doughnut charts show each cell’s data as a slice of doughnut. One or more doughnuts may be stacked on top of each other on the chart. Doughnut charts show the link between several types of data. Each doughnut presents a different piece of data.


What Are the Examples of Creating a Doughnut Chart in Excel?


Example 1 – Making a Doughnut Chart with a Single Data Series

  • Select the dataset that you want to include in your doughnut chart.
  • Go to the Insert tab.
  • Select Insert Pie or Doughnut Chart from the Charts options.

Choose Range of Cells in the Dataset

  • From the drop-down menu, choose Doughnut chart.

Choose Doughnut Chart Option

  • You will see a doughnut chart in your worksheet.

Show Doughnut Chart

  • Double-click on the Chart Title. You can type the relevant title of the chart.

Click on Chart Title in the Doughnut Chart to Add Chart Title

We have added a Chart title named “Sales Information”. Let’s add labels.

  • Right-click on the chart.
  • Select Add Data Labels.

Choose Add Data Labels

We want to change the color for better visualization.

  • Select the chart.
  • Click on Chart Styles.
  • Select a Style. We have selected the marked format in the image below, but you can select any other format you like.

Choose Desired Chart Style

You can also change the color of your doughnut chart.

  • Select the doughnut chart.
  • Go to Chart Styles and select Color.
  • Choose the color palette according to your preference. We have selected a color palette from the image.

Choose Desired Chart Color Style

You can modify the doughnut’s thickness and other parameters.

  • Choose the doughnut chart. The right side of the screen will display the Format Data Series pane.
  • We have kept it around 20 degrees here.
  • To alter the doughnut chat’s thickness, alter the size of the doughnut hole. We have kept it at 50%

Go to Format Data Series Window to Increase the Doughnut Ring Size

  • Here’s the result.

Show Doughnut Chart with Single Data Series


Example 2 – Making a Doughnut Chart with Two Data Series

  • Go to the Insert tab.
  • Select Insert Pie or Doughnut Chart from the Charts options.

Choose Insert Pie or Doughnut Chart

  • Click on the Doughnut chart option.

Choose Doughnut Chart

  • You will see a blank chart.
  • Right-click on the Doughnut chart and choose the Select Data option.

Choose Select Data Option

  • Click on Add.

Click Add from the Select Data Source Window

  • Insert “Series name” as cell C5 and “Series values” from as C6:C9 cells.
  • Click OK.

Choose Series name and Series values from the Dataset

  • Click on Add.

Click Add from the Select Data Source Window

  • Insert “Series name” as cell D5 and “Series values” as D6:D9 cells.
  • Click OK.

Choose Series name and Series values from the Dataset

  • On the right-hand side, choose Edit.

Click Edit from the Select Data Source Window

  • Add the Axis label range as B6:B9 cells.
  • Click OK.

Select Axis label range

  • Click OK.

Click OK from the Select Data Source Window

  • You will get your desired doughnut with two data series values.

Show Doughnut Chart with Two Data Series

Read More: How to Make a Doughnut Chart in Excel


How to Create a Doughnut Chart with Multiple Rings in Excel?

  • Select the dataset that you want to include in your doughnut chart.
  • Go to the Insert tab.
  • Select Insert Pie or Doughnut Chart from the Charts options.
  • From the drop-down menu, choose Doughnut chart.

Choose Doughnut Chart Option

  • You will see a doughnut chart in your worksheet
  • Change the chart title.

Click on Chart Title in the Doughnut Chart to Add Chart Title

  • We have added a Chart title named “Sales Information”.
  • Right-click on any doughnut rings and you will see the Format Data Series window.
  • Reduce the Doughnut Hole Size according to your preference for getting a better view of the chart.

Go to Format Data Series Window to Increase the Doughnut Ring Size

We will add data labels to your doughnut chart.

  • Click on the chart.
  • Select the Chart Elements option.
  • Choose Add Data Labels.

Choose Data Labels

You may also change the doughnut chart’s color as well.

  • Select the chart.
  • Navigate to Chart Styles.
  • Choose Color.
  • Choose the color scheme based on your personal preferences.

Choose Desired Chart Color Style

  • Here’s a sample doughnut chart with multiple rings.

Show Doughnut Chart with Multiple Rings

Read More: Excel Doughnut Chart with Multiple Rings


How to Make a Doughnut Chart with the Total in the Middle in Excel?

  • Select all the data.
  • Go to the Insert tab.
  • Click on the Insert Pie or Doughnut Chart option from the ribbon.
  • Choose the Doughnut chart.

Choose Doughnut Chart Option

  • You get a basic donut chart.

Show Customized Doughnut Chart

We want to add the total in the middle of the doughnut chart.

  • Choose the appropriate value to add in the middle. We want to represent the general average value for my dataset in the center of the doughnut chart.
  • Insert the following formula in the C9 cell.
=AVERAGE(C5:C8)
  • Press Enter to get the average value.

Use AVERAGE Function

  • Go to the Insert tab.
  • From the ribbon, click on the Text option.
  • Choose Text Box.

Choose Text Box

  • Place the Text Box in the center of the doughnut chart.

Place the Text Box in the Center of the Doughnut Chart

  • Go to the formula bar.
  • Use the following formula to represent the value in the middle of the doughnut chart.
=Total_in_Middle!$C$9
  • Hit Enter.

Use Formula to Represent the Value in the Middle of the Doughnut Chart

  • You will get the following output.

Show Doughnut Chart with Total in Middle in Excel

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


How to Make a Progress Doughnut Chart in Excel?

  • We have calculated the remaining percentage of the assignment with the following formula in the C6 cell.
=100%-C5
  • Press Enter.

Use Arithmetic Formula to Get the Remainder Value

  • Select the dataset that you want to represent in your doughnut chart.
  • Go to the Insert tab.
  • Select Insert Pie or Doughnut Chart from the Charts options.
  • From the drop-down menu, choose Doughnut chart.

Choose Doughnut Chart

  • You will see a doughnut chart in your worksheet.
  • Change the title of the chart.

Click Chart Title

  • Change the color of your doughnut chart.

Choose Desired Chart Color Style

  • Go to the Insert tab.
  • Click on the Text option.
  • Choose Text Box.

Choose Text Box

  • Place the Text Box in the center of the doughnut chart.
  • Go to the formula bar.
  • Insert the following formula to represent the progress value in the center of the doughnut chart.
=$C$5
  • Hit Enter.

Use Formula to Represent the Progress Value in the Center of the Doughnut Chart

  • Here’s the result. We modified the textbox a bit.

Show Progress Doughnut Chart in Excel

Read More: How to Create Progress Doughnut Chart in Excel


Things to Remember

  • To access the modifying tools, you need to select the doughnut chart.
  • To make a doughnut chart with many rings, you should have a dataset with multiple rows and columns.
  • Doughnut charts are similar to pie charts and have a central hole.
  • Doughnut charts are useful when creating visualizations with single, double, or multiple matrices.
  • Making a chart for 100% matrices is often useful.
  • There are single-doughnut, double-doughnut, and multiple-doughnut charts available.

Frequently Asked Questions

In Excel, how can I make a Doughnut chart?

To make a doughnut chart in Excel, choose the data for the chart, then go to the Insert tab, click the “Insert Pie or Doughnut Chart” button, and then select the “Doughnut” chart type from the selections.

Can I change the colors of the Doughnut chart segments?

Yes, the colors of the segments in a doughnut chart can be changed. Select the chart, navigate to the Chart Tools Format tab, click the “Shape Fill” or “Shape Outline” button, and select the required color or a custom color scheme.

How can I add labels to the Doughnut chart segments?

To add labels to doughnut chart segments, select the chart, navigate to the Chart Tools Format tab, click the “Data Labels” button, and select the desired labeling option, such as showing the category name, value, or percentage.

In Excel, can I modify the size of the Doughnut chart?

In Excel, you may alter the size of the doughnut chart. Select the chart, then modify the width and height by dragging the scaling handles or entering the exact dimensions in the Format Chart Area box.


Excel Doughnut Chart: Knowledge Hub


<< Go Back to Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Tags:

Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

2 Comments
  1. Hi Bishawajit, this was very helpful to me in understanding some Doughnut charts added in our reports, I can now create and edit these more comfortably.

    I, however, was running into an issue with Text Boxes between the Desktop Excel application and Online Excel. I have posted the question here:

    https://techcommunity.microsoft.com/t5/excel/textbox-hides-behind-doughnut-chart-in-online-excel-but-is/m-p/4086621#M224130

    I would highly appreciate any tips you have may have to resolve this issue.

    Thanks.

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Mar 18, 2024 at 3:20 PM

      Hello Vipin

      Thanks for your nice words. Your appreciation means a lot to us.

      You are facing an issue with a worksheet with a Doughnut chart and a textbox in its center to display a value from another cell. The textbox is visible on the desktop version of Excel but not on the online version.

      You have tried moving the textbox to the front using Bring to Front, but it doesn’t work. You have also tried sending the chart to the back using Send to Back, but it doesn’t help either.

      The issue might be browser-specific. Different web browsers sometimes display online applications differently. For example, I do not have this type of issue at all.

       

      You may be using an older Excel Online version with this bug. Microsoft frequently updates Excel Online, and they might have fixed the issue in newer versions. Check if there are any updates available.

      Regards
      Lutfor Rahman Shimanto
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo