Doughnut chart can obviously show the percentage and the contribution of every part for the overall. Now I will tell you how to create a doughnut chart in Excel.
To create doughnut chart is very easy, just follow the steps:
1. Select the data range you need to be shown in the doughnut chart, and click Insert > Other Charts > Doughnut. See screenshot:
In Excel 2013, click Insert > Insert Pieor Doughnut Chart > Doughnut. See screenshot:
2. Then a doughnut chart is inserted in your worksheet. Now you can right click at all series and select Add Data Labels from the context menu to add the data labels. See screenshots:
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...