Pie-on-pie charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to create several 'pie on pie' charts. I have created a couple before
and they seemed to work ok, apart from one problem. The 'slice' in the main
pie from which the second pie is created (the 'other' slice) seems to
determine its own size, however, I need to specify the exact size of this
slice and can't seem to find how to do it.

Below is an example of the kind of data I have to work with. We have sent
out 700 application forms, received 200 replies and we have then got the
average scores from each application form. The first pie chart needs to
contain a slice for 700 and another for 200. 'Branching' off the 200 slice
should be the second pie chart consists of the scores.

Again, I have created these before but the 200 slice didn't actually
represent 200, as Excel creates it as an 'other' slice and defines the size
of it itself?

Can anybody help on this??

Sent Out Received back V Good Good Average Poor
700 200 6.8 9.69 2.4 0.55

THank you.
Louise
 
Hello, thank you for your reply.

I have already looked at this website and still couldn't get it to work,
however, I think you're right, I am going to have to re-calculate the score
values in the original table.

Not as easy as I thought it was going to be........

Thanks again.
 
I know it seems elegant to have everything in a single chart, but sometimes
it's easier to make two charts, and place them near each other (sometimes
two charts is simpler than one). Format the chart area of the chart in front
so it's transparent (no fill), and it won't obscure the other chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon
Thank you for your reply. To be honest, I never thought of doing two, may
be I should give this a go.

In my opinion, Microsoft haven't made the pie-on-pie charts as user friendly
as they need to be...!!

Thanks again.
Louise
 
Back
Top