Pie Chart with Subdivisions

mymorninghatchet

New Member
Joined
Nov 27, 2013
Messages
1
Hey all,

I have a question regarding pie charts. Basically I have a chart with 9 different categories broken up by percentages. I can create this general chart with no problem.

However, within each of these 9 categories, I also have data sets for multiple sub categories. I want to show another pie chart using the same 9 data labels, but each of them would be broken out into several smaller slices. I do not want to use a pie-in-pie chart.

See the images below for examples:

<a href="http://imgur.com/IloiSAu">Simple Chart</a>
<a href="http://imgur.com/Qs9wSd4">Detailed Chart</a>

Any ideas?
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

btomjack

Board Regular
Joined
Sep 13, 2013
Messages
229
Idea: don't use pie charts. If you're comparing 2 or 3 categories, they might be acceptable, but 9 categories is probably too many to be easy to understand.

Try using stacked bar charts; this will allow you to accomplish both of your goals. Firstly, your original chart (with the 9 categories) could be easily compared by height to see which category has the greatest percent of the whole. Secondly, inside each of the 9 bars, your sub-categories could be represented by different colors.

The link below has some graphics that illustrate what I mean:
Why Pie Charts are Evil | Catbird Analytics
Scroll down to the 2 pictures of bar charts, and the one on the left is the kind of stacked bar chart to which I am referring.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,921
Messages
5,411,254
Members
403,353
Latest member
ecboy1605

This Week's Hot Topics

Top