Doughnut Chart is also used to display each category’s contribution parts of a whole number.
for example if we have to showcase employee wise revenue then we can use Doughnut chart to show the each employee contribution in overall revenue.
In the above picture, we have displayed Category Name(Employee Name) in the legends, Percentage (contribution in overall) in data labels. Below is the employee wise revenue which we have used to create this chart.
To create this Pie chart below steps to be followed-
- Select the data range like “A1:B6”.
- Go to Insert>>Charts>>Pie Chart >> Doughnut
After successfully inserting the a Doughnut chart, we will change the style of this Doughnut chart.
Click on the charts, “Design” Tab will be visible under “Chart Tool”. We can choose any of the design but this chart we will select style 3.
Our doughnut chart is ready. Please download this excel file for practice.