Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Create Doughnut Chart in Excel
The distribution and proportions of various categories are easier to comprehend when data is represented in a circular fashion using doughnut charts, which are an effective visual aid. Doughnut charts can offer insightful information at a glance when assessing sales data, survey results, or any other type of data with discrete categories.
We'll walk you through every step of making a doughnut chart in Excel in this tutorial. We'll go through everything you need to know, including how to prepare your data, choose the right sort of chart, alter the elements of the chart, and add the finishing touches to make your chart both aesthetically pleasing and educational. By the end of this tutorial, you will have a thorough understanding of how to make a doughnut chart in Excel and be prepared to use this potent chart type to effectively present your data. So, let's get started and learn more about doughnut charts in Excel!
Create Doughnut Chart in Excel
Here, we will first create the chart and then add the data labels to it. So let us see a simple process to know how you can create a doughnut chart in Excel.
Step 1
Consider an Excel sheet where you have appropriate data to create a doughnut chart similar to the below image.
First, select the range of cells, then click on insert and select Doughnut Chart.
Select cells > Insert > Doughnut Chart.
Step 2
Then you can see that the doughnut chart was created successfully. Now to add the data labels, right-click on the sheet and select Add Data Labels.
Right click > Add Data Labels.
This is how you can create a doughnut chart in Excel.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can create a doughnut chart in Excel to highlight a particular set of data.
159 Views
