If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
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) |
#2
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
Hi,
Maybe something here will help. http://www.andypope.info/charts/pies.htm Cheers Andy Philip Mark Hunt wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
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" wrote: Hi, Maybe something here will help. http://www.andypope.info/charts/pies.htm Cheers Andy Philip Mark Hunt wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
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 Philip Mark Hunt wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
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 ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Philip Mark Hunt wrote: 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) |
#6
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
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" wrote: 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 Philip Mark Hunt wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
#7
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
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 Philip Mark Hunt wrote: 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" wrote: 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 Philip Mark Hunt wrote: 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, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#8
|
|||
|
|||
Pie Chart displayed on top of a Pie Chart
You may want to check
Progress towards a goal http://localhost/tushar/excel/charts...rds_a_goal.htm On Fri, 9 Oct 2009 23:28:01 -0700, Philip Mark Hunt wrote: 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 |
Thread Tools | |
Display Modes | |
|
|