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:
- Create a Doughnut Chart
- Customize the Doughnut Chart
- 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.
Read More: How to Create Curved Labels in Excel 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.
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.
- 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.
Download Practice Workbook
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!