How to Make a Doughnut Chart in Excel

Doughnut Charts Show the Relationship of Parts to a Whole

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

The charts below were made using the data to the right.

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

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

 

 

doughnut chart data


Doughnut Chart

doughnut chart created in Excel

 

 

Pie Chart

pie chart in excel


Doughnut Charts 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

 

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 the QI Macros menu on your Excel toolbar and select Pareto Chart. QI Macros will do all of the math and draw the chart for you.

create a pareto

Interpreting the Pareto Charts

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

pareto for 214 errors

pareto of 2015 errors

Purchase QI Macros for Excel through our secure shopping cart or try, QI Macros Absolutely Free!