"Pie of Pie" problem in Excel 2007

[katrina11]

Hi Experts,
I have a population of patients=3981 with certain diagnosis .
-1478 of them met a certain medical procedure 1478/3981=37.1%
-while the rest of them did not 2503/3981=62.9%
-Besides the 1st category should be split up into categories: Teaching hospital and other hospitals (14.8% vs.22.3%)=37.1%

Main Pie should show three sectors: 14.8%; 22.3% and 62.9%. It will show “the whole picture of those,who got a certain procedure split into Hospital category(14.8%; 22.3%) and those who do not get it.

While pie-of-pie (smallest pie) should have 60.1% and 39.3%, illustrating what pct of those
who got a procedure, is greater for teaching hospitals. In other words small pie should show a proportion by Hospital categories
just among patients who had a procedure . So far I believe that GRAPH “Pie of Pie” is the best choice for this purpose.

I organized data in Excel like shown below an did INSERT-> "PIE OF PIE":

w/o proc 62.90% 0.00%
T-Hosp w proc 22.30% 60.10%
O-Hosp w proc 14.80% 39.90%

The main pie is OK but the small one just doesn't show what I I need ....
Would it be possible to do what I am trying to do in this way?
What would youi recommend otherwise?

Any help will be greately appreciated!

Katrin

 

[GlennUK]

I think pie of pie is best to show this, but I don't agree on what you think the chart should look like. I think the main chart should show w/o proc ( 62.9% ) and other ( 37.1% ), and the pie of pie should show T-Hosp w proc ( 22.3% ), and O-Hosp w proc ( 14.8% ). That is also very simple to achieve.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[katrina11]

Hi Glenn,

Thank you for the response. Actually, I would agree with what you said. However I still have the same problem making a chart.

Main pie looks OK while pie of pie shows just 22,3% and does not show 14.8 at all...

What I am doing incorrect? That is how I organized data for the chart.

37.10% 22.30%
62.90% 14.80%

Thank you!

Katrin

 

[GlennUK]

I put the data like this:
[tt]
w/o proc 2503
T-Hosp w proc 590
O-Hosp w proc 888
[/tt]

created a pie of pie, selected the lesser pie, pressed Ctrl-1, and chose to have the last 2 points as pie of pie.

Cheers, Glenn.

Beauty is in the eye of the beerholder.