Need to Draw a Doughnut Chart in Excel?

QI Macros makes doughnut charts easy
...AND can draw even smarter charts to analyze your data!

Doughnut Charts Show the Relationship of Parts to a Whole

Use a Doughnut Chart for two or more series of data and a Pie Chart when you have one data series.

The charts below were made using this medication errors data.

The doughnut chart displays data in columns B and C. Errors for Baseline data in column B are on the inner ring and errors for column C are on the outer ring.

The pie chart only displays the baseline data in column B.

doughnut chart data

Doughnut Chart

doughnut chart created in Excel

Pie Chart

pie chart in excel

How to Create a Doughnut Chart in Excel

To create a doughnut chart in Excel, select your data, then click on the Insert tab, then Other Charts and then Doughnut. There two choices of chart shapes - regular and exploded.

how to make a doughnut chart in excel

Consider Pareto Charts for More Advanced Analysis

As you can tell, a doughnut chart is fairly difficult to read. If you look at the chart above: Is there a problem? What is it? What action should you take?

A much better chart to analyze this data is the Pareto Chart. It's hard to create a Pareto Chart in Excel, but its easy using an add-in like QI Macros. Just select your data, click on QI Macros menu on your Excel tool-bar and select Pareto Chart. QI Macros will do all of the math and draw the chart for you.

create a pareto

Interpreting Pareto Charts

QI Macros Pareto chart tells us that Wrong Technique (the first and biggest bar) with 41 errors accounted for 45.1% of baseline Medication Errors. If we focus on just this type of error, we will be addressing almost half of the errors. The after 6 month pareto shows Wrong Technique as the second biggest bar at only 5 errors, accounting for only 23% (70% - 53.3%) of the total. An improvement team must have figured out a way to prevent many of the errors due to wrong technique!

baseline pareto for med errors

pareto for med errors after 6 months

Stop using old technology!

Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.

Track Data Over Time

Primitive Chart
line graph
Line Graph
Smart Chart
control chart
Control Chart

Compare Categories

Primitive Chart
pie chart
Pie Chart
Smart Chart
pareto chart
Pareto Chart

Analyze Variation

Primitive Chart
bar or column chart
Bar or Column Chart
Smart Chart

QI Macros add-in for Excel makes creating smart charts a snap.