Excel Percentage Donut Chart: Step-by-Step Guide

Gregory Jul 09, 2026

Ever needed to visualize percentage data in Excel? A percentage donut chart is an excellent way to do this, as it allows for easy comparison and understanding of data. Here's a step-by-step guide on how to create one.

How to Create a Sliced Donut Chart in Excel | Easy Step-by-Step Guide
How to Create a Sliced Donut Chart in Excel | Easy Step-by-Step Guide

Before we dive in, ensure you have a dataset with percentage values. If your data is in decimal form, you can easily convert it to percentage by multiplying by 100. For instance, 0.5 becomes 50%.

Donut Chart - Learn about this chart and tools to create it
Donut Chart - Learn about this chart and tools to create it

Preparing Your Data

Start by organizing your data in a table. The first row should contain labels or categories, and the second row should have the corresponding percentage values.

Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]
Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]

For example, if you're comparing sales of three products, your table might look like this:

ProductSales (%)
Product A40%
Product B35%
Product C25%
Pie and Donut Chart Templates
Pie and Donut Chart Templates

Creating the Donut Chart

Now that your data is ready, let's create the donut chart.

1. **Select your data**: Click and drag to select the entire range of data, including the headers.

How to Make an Expanding Donut Chart in Tableau
How to Make an Expanding Donut Chart in Tableau

2. **Insert the chart**: Click on 'Insert' in the Excel ribbon, then click on 'Pie' or 'Other Charts' (depending on your Excel version) and select 'Doughnut Chart'.

Customizing the Chart

Once the chart is created, you can customize it to better suit your needs.

How to build a fantastic 10-minute Tableau Donut chart!
How to build a fantastic 10-minute Tableau Donut chart!

1. **Change the chart type**: Right-click on the chart and select 'Change Chart Type'. Then, choose 'Pie' and 'Doughnut' to switch between the two types.

2. **Add data labels**: Right-click on the chart, select 'Add Data Labels', and then 'Percentage'. This will display the percentage values on the chart.

Progress Circle Chart in Excel - Part 1 of 2
Progress Circle Chart in Excel - Part 1 of 2
Progress Doughnut Chart with Conditional Formatting in Excel - Excel Campus
Progress Doughnut Chart with Conditional Formatting in Excel - Excel Campus
Infographics: Filling Circle Chart in Excel
Infographics: Filling Circle Chart in Excel
Donut Chart in Excel for a Beautiful Dashboard Design
Donut Chart in Excel for a Beautiful Dashboard Design
Double Doughnut Chart in Excel
Double Doughnut Chart in Excel
How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
MS Excel 2016: How to Create a Pie Chart
MS Excel 2016: How to Create a Pie Chart
Multi Level Pie Chart - Best Excel Tutorial
Multi Level Pie Chart - Best Excel Tutorial
Use Donut Bar Charts to Display Product-wise Sales Breakup - Excel Charting Tutorial & Download
Use Donut Bar Charts to Display Product-wise Sales Breakup - Excel Charting Tutorial & Download
Easy example of 3D Pie chart with value than 100% in Excel
Easy example of 3D Pie chart with value than 100% in Excel
How to Build this Rounded Two Tone Donut Chart?
How to Build this Rounded Two Tone Donut Chart?
the progress circle chart in excel
the progress circle chart in excel
How To Create A Pie Chart In Excel (With Percentages)
How To Create A Pie Chart In Excel (With Percentages)
Stylish Doughnut Charts in Excel - PK: An Excel Expert
Stylish Doughnut Charts in Excel - PK: An Excel Expert
Progress Circle Chart in Excel - Part 1 of 2
Progress Circle Chart in Excel - Part 1 of 2
How to Create a Pie Chart in Excel (Free Template)
How to Create a Pie Chart in Excel (Free Template)
an image of different colored circles with the words donut chart
an image of different colored circles with the words donut chart
Calculate percentage in excel
Calculate percentage in excel
Semi-Donut Chart with 7 Parts for PowerPoint and Google Slides
Semi-Donut Chart with 7 Parts for PowerPoint and Google Slides
Create a Progress Circle Chart in Excel for Your Dashboard
Create a Progress Circle Chart in Excel for Your Dashboard

3. **Format the chart**: Use the 'Format Selection' tools that appear when you click on an element of the chart to change colors, fonts, and other design elements.

Interpreting the Chart

Once your chart is complete, you can use it to compare and understand your percentage data.

For instance, in our sales example, you can see that Product A has the highest sales at 40%, followed by Product B at 35%, and then Product C at 25%.

Tips for Effective Use

1. **Keep it simple**: Donut charts work best with a small number of data points. If you have too much data, consider using a different chart type.

2. **Use clear colors**: Make sure your colors are distinct and easy to distinguish from one another. Avoid using too many colors or colors that blend together.

Creating a percentage donut chart in Excel is a great way to visualize and understand your data. With a bit of practice, you'll be creating engaging and informative charts in no time. Happy charting!