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

Does anybody have any help on this??? I'm really stuck...... :(

Thank you.

"Louise" wrote:

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

Hi,

The article by Jon Peltier explains all about pie of pie and how the
Others category is constructed.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

I think you will need to recalculate the score values to be a proportion
of the 200.

Cheers
Andy

Louise wrote:
Does anybody have any help on this??? I'm really stuck...... :(

Thank you.

"Louise" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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.

"Andy Pope" wrote:

Hi,

The article by Jon Peltier explains all about pie of pie and how the
Others category is constructed.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

I think you will need to recalculate the score values to be a proportion
of the 200.

Cheers
Andy

Louise wrote:
Does anybody have any help on this??? I'm really stuck...... :(

Thank you.

"Louise" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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


"Louise" wrote in message
...
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.

"Andy Pope" wrote:

Hi,

The article by Jon Peltier explains all about pie of pie and how the
Others category is constructed.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

I think you will need to recalculate the score values to be a proportion
of the 200.

Cheers
Andy

Louise wrote:
Does anybody have any help on this??? I'm really stuck...... :(

Thank you.

"Louise" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

"Jon Peltier" wrote:

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


"Louise" wrote in message
...
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.

"Andy Pope" wrote:

Hi,

The article by Jon Peltier explains all about pie of pie and how the
Others category is constructed.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

I think you will need to recalculate the score values to be a proportion
of the 200.

Cheers
Andy

Louise wrote:
Does anybody have any help on this??? I'm really stuck...... :(

Thank you.

"Louise" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info