X

How To Make A Progress Doughnut Chart In Excel

The doughnut chart is a one kind of pie chart. It’s very easy to understand, and you can always see them in news or business report. More important is that doughnut chart is extremely easy to create. Let’s get started.

Basic Table

We need to prepare a basic table first. Take an example like below.

You need to note that the sum of the complete percentage and the remaining percentage of each group is one. Just in case you can type formula =1-B2 in cell B3, the same as C3 and D3.

Insert Chart

Highlight the table and go to insert to get Doughnut chart quickly.

You can adjust the size, color or other effects to make the chart more beautiful.

Complete All the Charts

After you finish the first doughnut chart, do the same to the next two. And then you will get three perfect charts.

Categories: Excel Tips
Sandra: