# 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.

## 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.

• 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.

### 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.

• 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 like changing the hole size of the Doughnut Chart from Format Data Point option.

• Add a suitable title from the Chart TitleÂ section.

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.

### 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.

• 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.

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.

• 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.

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

## 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. Goodbye!

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF