Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Make A Progress Doughnut Chart In Excel

Date:2021-3-22 Author:Sandra

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.

How To Make A Progress Doughnut Chart In Excel

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.

How To Make A Progress Doughnut Chart In Excel

Insert Chart

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

How To Make A Progress Doughnut Chart In Excel
How To Make A Progress Doughnut Chart In Excel

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

How To Make A Progress Doughnut Chart In Excel
How To Make A Progress Doughnut Chart In Excel

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.

How To Make A Progress Doughnut Chart In Excel
How To Make A Progress Doughnut Chart In Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *