Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Make Doughnut Chart with Total in Middle in Excel

Doughnut Chart is an amazing feature in Excel. It helps to visualize any statistical difference quite magnificently. We can also add the total value in the middle o the doughnut section to make it more clear for others. In this article, I am going to explain every single step to make Excel Doughnut Chart with total in middle.


Download Practice Workbook


Doughnut Chart Introduction

In Excel, there is a built-in chart type which is referred as Doughnut Chart. The doughnut chart is a variation on the pie chart that shows categories as arcs rather than slices and has a hole in the center.
The Doughnut Charts assist in visually accurate and clean data representation when comparing sets of data in Excel. The doughnut charts, as opposed to pie charts, can display many data sets on an Excel sheet. Additionally, Doughnut Charts’ data values are simple to modify or replace in real-time in accordance with our needs.


Steps to Make Doughnut Chart with Total in Middle in Excel

I have explained the whole making of an Excel doughnut chart with the total in middle in 3 steps.
They are:

  1. Create a Doughnut Chart
  2. Customize the Doughnut Chart
  3. Add total in the middle of the Doughnut Chart

The steps are explained in short and simple words in the following sections.


Step-01: Create a Doughnut Chart

Firstly, I have to create a Doughnut Chart in the beginning of the whole procedure.

Steps:

  • First of all, create a dataset. I have created a dataset with an institution’s average marks in different subjects. I have categorized them into the Subject and Average Marks columns.

 Excel Doughnut Chart with Total in Middle

  • Next, select all the data.
  • Go to the Insert tab.
  • Click on Insert Pie or Doughnut Chart option from the ribbon.
  • Then, choose the Doughnut option.

Thus, we will have a doughnut chart.

 Excel Doughnut Chart with Total in Middle

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


Step-02: Customize the Doughnut Chart

In the second step of the whole procedure, we are going to customize the doughnut chart based on our choice.

Steps:

  • Right-click on a portion of the doughnut chart to change its color.
  • Click on the Fill option.
  • Choose a color.

The will be set as the color of that portion of the doughnut chart. You can change the color of each portion of the doughnut according to your choice.

 Excel Doughnut Chart with Total in Middle

  • Click on the doughnut chart to have more editing options.

From the available options, you can edit your whole doughnut chart. You can also change the shape of the doughnut from the Doughnut Hole Size option.

  • Add a suitable title from the Chart Title section.

 Excel Doughnut Chart with Total in Middle

In this section, I have added a doughnut chart where I have customized the color of several portions of the doughnut chart, added a suitable title, and enhanced the doughnut size.

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


Step-03: Add Total in the Middle of Doughnut Chart

The last and another important remaining step is to add the total in the middle of the doughnut.

Steps:

  • Find the suitable value to add in the middle. For my dataset, I want to add the overall average value in the middle of the doughnut chart. For this reason, I have calculated the average of those institutions in combined subjects. I have used the following formula to calculate the average.
=AVERAGE(C5:C10)

Where, the AVERAGE function returns the average value in cells C5:C10.

 Excel Doughnut Chart with Total in Middle

  • Press ENTER to have the average value.

  • Next, go to the Insert tab.
  • From the ribbon, click on the Text option.
  • Then, choose Text Box.

 Excel Doughnut Chart with Total in Middle

Thus, we will have a text box.

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

  • Now, go to the formula bar.
  • Input the following formula to mention the value in the middle of the doughnut chart.
='Doughnut Chart'!$C$11

Here, Doughnut Chart signifies the worksheet name and C11 represents that the value in that cell will be shown in the middle of the doughnut chart.

 Excel Doughnut Chart with Total in Middle

  • Press ENTER to have the output in the middle of the doughnut chart.

  • Finally, customize the font size, and position of the output to have a better outlook.

 Excel Doughnut Chart with Total in Middle

This is how we can have Excel Doughnut Chart with the total in middle.

Read More: Excel Doughnut Chart with Multiple Rings (Create with Easy Steps)


Conclusion

That’s all for the article. In this article, I have tried to explain every single steps to make an Excel doughnut chart with the total in middle. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo