Pie Chart displayed on top of a Pie Chart

[Philip Mark Hunt]

Greetings

I am seeking to display what I can only describe as a Pie on top of a Pie.
I have two values Available = 497 and Held = 200. I want to have a large pie
showing the 497 and then on top of that a smaller pie showing the 200 centred
over the larger pie. Over time, as I get more of the available set of books,
the Held Pie will steadily cover over, and eventually totally hide, the
available pie.

While I have for now taken Jon Peltier's suggestion, in his post of 12th Dec
2008, as an interim compromise solution to my desired result, i.e have two
values, one of 297 and one of 200 and then do a Pie of Pie chart, I am
wondering if there is some other way, even possibly by some special add on,
like Laurent's morefunc, which has helped me greatly.

I have drawn a rough Paint JPG of what I want to achieve, but am unable to
post it here.

Any advice would be very welcome.

Best regards

Philip Hunt
Perth, Western Australia
(Running Excel 2007 SP2)

 

[Andy Pope]

Hi,

Maybe something here will help.
http://www.andypope.info/charts/pies.htm

Cheers
Andy

 

[Philip Mark Hunt]

Hello Andy

Thank you for the direction. I am sorry but the instructions there are just
not idiot proof enough for me. I have baulked at step 2 - "Select data
series Outer and format on to Secondary axis". I cannot work out how to
format on to secondary axis.

I have tried format data point and there is nothing about axis there, and
when I switch row column under select data source, and then proceed to
convert the outer series to a pie.all I get is a pie totally covering the
inner series.

I am no dummy with Excel, but I really do need step by step instructions
with explicit statement of what instruction windows to select etc. , and your
example does not provide that.

Thank you for trying - I think what I need may be there, but it is just too
hard as you have currently presented it.

Regards

Philip

 

[Andy Pope]

Hi,

Thanks for the feedback.

Select the data series and display the format dialog.
You can do this with any of the following;
CTRL+1
or double-click
or via menu Format > Selected Data series
or the chart toolbar, Format data series.

Then use the Axes tab to set which axis to use.

I accept my instruction maybe missing full instructions. It's a problem
of being familiar with using charts more than most and not being a
professional help writer

Cheers
Andy

 

[Jon Peltier]

Tufte once said (and I paraphrase) that the only thing worse than a pie
chart was multiple pie charts.

Could you simply show a bar chart with two darkly formatted bars, for
held and available, and under held list the constituents of held. It
would comprise two series:

Avail 497
Held_ 200
Held1 45
Held2 30
Held3 27
etc. ..

- Jon

 

[Philip Mark Hunt]

Hi Andy

Thank you for the further pointers. I am on Office 2007, and your
instructions seem to be 2003 related, but I have tried to 'translate' them.

In order to learn from your pies spreadsheet, I am trying to reproduce your
result in 2007.

On line help for 2007 in one of the articles that referes to axes, includes -

"On the Format tab, in the Current Selection group, click the arrow next to
the Chart Elements box, and then click Vertical (Value) Axis". I have tried
that and find nothing called Vertical (Value) Axis come up.

Further down it refers to "Click Axis Options", and again that does not come
up at all, whatever I choose.

While writing this reply I looked at the 2007 help a bit more, and that
alerted me to the Axes group on the Layout tab. I notice that while I am
able to reproduce, in 2007, Step 1 in your step by step instructions, the
Axes tab is greyed out when producing a two level doughnut like that, and
therefore it would appear that step 2 cannot be done.

Thank you for trying to help me, if you or anyone else has any other ideas I
would be pleased to hear them.

Regards

Philip
Perth, Western Australia

 

[Andy Pope]

It always help to state what version of excel you are using.
Yes some of the instructions would be meaningless for xl2007.

You can do it but in the 1st step create a pie chart rather than a
donut. Select the pie and format it. The Secondary axis option is
displayed on the Series Option page. From there on the steps are the same.

Cheers
Andy

 

[Tushar Mehta]

You may want to check
Progress towards a goal
http://localhost/tushar/excel/charts/progress_towards_a_goal.htm

Greetings

I am seeking to display what I can only describe as a Pie on top of a Pie.
I have two values Available = 497 and Held = 200. I want to have a large pie
showing the 497 and then on top of that a smaller pie showing the 200 centred
over the larger pie. Over time, as I get more of the available set of books,
the Held Pie will steadily cover over, and eventually totally hide, the
available pie.

While I have for now taken Jon Peltier's suggestion, in his post of 12th Dec
2008, as an interim compromise solution to my desired result, i.e have two
values, one of 297 and one of 200 and then do a Pie of Pie chart, I am
wondering if there is some other way, even possibly by some special add on,
like Laurent's morefunc, which has helped me greatly.

I have drawn a rough Paint JPG of what I want to achieve, but am unable to
post it here.

Any advice would be very welcome.

Best regards

Philip Hunt
Perth, Western Australia
(Running Excel 2007 SP2)

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins