Pie-on-pie charts

L

Louise

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
 
L

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.
 
J

Jon Peltier

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/
_______
 
L

Louise

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie of Pie Chart type with smaller pie showing slices of main slic 2
Doughnut Chart linked with the slicer in the pivot table 0
How can I reset the default pie chart label "Other" to "Equity"? 1
Pie of Pie 0
Pie Chart Options 1
Can I make a pie chart where the slices are also graphical? 4
Pie Chart that Shows Values instead of Percentages 1
changing default fill for balck and white pie graph 2

Top