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
|
|||
|
|||
Exploded pie charts
I want to "explode" two slices together on a pie chart.
That is 4 of the 6 pie slices would not be exploded and the two others would be exploded as a single wedge but with two different colors. Any hints or solutions? |
#2
|
|||
|
|||
Exploded pie charts
Dan -
In Excel, you can only explode a pie chart uniformly. You can't just blow up independent wedges. One workaround is to hold Shift while selecting Copy Picture from the Edit menu, selecting the On Screen and As Picture options, pasting the picture of the chart, and ungrouping it. Now you can move the wedges independently. I didn't like the way this worked. Another option is to make two copies of the chart. One one chart, format the two wedges you want to explode to be invisible (no border, no fill); on the other chart, hide all the other wedges the same way. Explode the one chart, format the chart area of the top chart to be invisible, and line them on top of each other. I didn't like this too much, either, but with some resizing and repositioning of the plot areas of the two charts, you might get something you can live with. If you do a lot of this, you could probably write some VBA code that algebraically sets the plot area sizes and the degree of explosion of the charts. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dan wrote: I want to "explode" two slices together on a pie chart. That is 4 of the 6 pie slices would not be exploded and the two others would be exploded as a single wedge but with two different colors. Any hints or solutions? |
#3
|
|||
|
|||
Exploded pie charts
Hi,
It is possible to explode all slices in a pie to different distances from the center. But you can not automatically keep 2 slices side by side. As the slices explode they do so along their own radius/angle. Which causes the slices to move away from each other. So, this is how you explode the pie. Start by selecting the pie and then drag a slice, this will as Jon said cause the pie to explode, scattering all slices at once. Now select a single slice, one you do NOT want to be exploded, drag this back towards the center of the pie. Repeat for all slices that are not required. If you really want the slices to be together then this will require using the pie to create custom markers for an xy-scatter chart. The positioning of the custom markers requires some trig formula. (If you really need the slices together email me and I will try and locate an example I have previously done) Jon Peltier wrote: Dan - In Excel, you can only explode a pie chart uniformly. You can't just blow up independent wedges. One workaround is to hold Shift while selecting Copy Picture from the Edit menu, selecting the On Screen and As Picture options, pasting the picture of the chart, and ungrouping it. Now you can move the wedges independently. I didn't like the way this worked. Another option is to make two copies of the chart. One one chart, format the two wedges you want to explode to be invisible (no border, no fill); on the other chart, hide all the other wedges the same way. Explode the one chart, format the chart area of the top chart to be invisible, and line them on top of each other. I didn't like this too much, either, but with some resizing and repositioning of the plot areas of the two charts, you might get something you can live with. If you do a lot of this, you could probably write some VBA code that algebraically sets the plot area sizes and the degree of explosion of the charts. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dan wrote: I want to "explode" two slices together on a pie chart. That is 4 of the 6 pie slices would not be exploded and the two others would be exploded as a single wedge but with two different colors. Any hints or solutions? -- Cheers Andy http://www.andypope.info |
#4
|
|||
|
|||
Exploded pie charts
In fact the separate slice split is even simplier.
Just select the pie and then select the slice. Drag the single slice. No need to explode and rebuild. Andy Pope wrote: Hi, It is possible to explode all slices in a pie to different distances from the center. But you can not automatically keep 2 slices side by side. As the slices explode they do so along their own radius/angle. Which causes the slices to move away from each other. So, this is how you explode the pie. Start by selecting the pie and then drag a slice, this will as Jon said cause the pie to explode, scattering all slices at once. Now select a single slice, one you do NOT want to be exploded, drag this back towards the center of the pie. Repeat for all slices that are not required. If you really want the slices to be together then this will require using the pie to create custom markers for an xy-scatter chart. The positioning of the custom markers requires some trig formula. (If you really need the slices together email me and I will try and locate an example I have previously done) Jon Peltier wrote: Dan - In Excel, you can only explode a pie chart uniformly. You can't just blow up independent wedges. One workaround is to hold Shift while selecting Copy Picture from the Edit menu, selecting the On Screen and As Picture options, pasting the picture of the chart, and ungrouping it. Now you can move the wedges independently. I didn't like the way this worked. Another option is to make two copies of the chart. One one chart, format the two wedges you want to explode to be invisible (no border, no fill); on the other chart, hide all the other wedges the same way. Explode the one chart, format the chart area of the top chart to be invisible, and line them on top of each other. I didn't like this too much, either, but with some resizing and repositioning of the plot areas of the two charts, you might get something you can live with. If you do a lot of this, you could probably write some VBA code that algebraically sets the plot area sizes and the degree of explosion of the charts. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dan wrote: I want to "explode" two slices together on a pie chart. That is 4 of the 6 pie slices would not be exploded and the two others would be exploded as a single wedge but with two different colors. Any hints or solutions? -- Cheers Andy http://www.andypope.info |
#5
|
|||
|
|||
Exploded pie charts
Andy -
I played with that stupid pie chart for a half hour, and couldn't make the pie slices move separately. I read your post and said sure, doesn't work. But I tried it again, and it did work. Learn something every day. Thanks for teaching. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Andy Pope wrote: In fact the separate slice split is even simplier. Just select the pie and then select the slice. Drag the single slice. No need to explode and rebuild. Andy Pope wrote: Hi, It is possible to explode all slices in a pie to different distances from the center. But you can not automatically keep 2 slices side by side. As the slices explode they do so along their own radius/angle. Which causes the slices to move away from each other. So, this is how you explode the pie. Start by selecting the pie and then drag a slice, this will as Jon said cause the pie to explode, scattering all slices at once. Now select a single slice, one you do NOT want to be exploded, drag this back towards the center of the pie. Repeat for all slices that are not required. If you really want the slices to be together then this will require using the pie to create custom markers for an xy-scatter chart. The positioning of the custom markers requires some trig formula. (If you really need the slices together email me and I will try and locate an example I have previously done) Jon Peltier wrote: Dan - In Excel, you can only explode a pie chart uniformly. You can't just blow up independent wedges. One workaround is to hold Shift while selecting Copy Picture from the Edit menu, selecting the On Screen and As Picture options, pasting the picture of the chart, and ungrouping it. Now you can move the wedges independently. I didn't like the way this worked. Another option is to make two copies of the chart. One one chart, format the two wedges you want to explode to be invisible (no border, no fill); on the other chart, hide all the other wedges the same way. Explode the one chart, format the chart area of the top chart to be invisible, and line them on top of each other. I didn't like this too much, either, but with some resizing and repositioning of the plot areas of the two charts, you might get something you can live with. If you do a lot of this, you could probably write some VBA code that algebraically sets the plot area sizes and the degree of explosion of the charts. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dan wrote: I want to "explode" two slices together on a pie chart. That is 4 of the 6 pie slices would not be exploded and the two others would be exploded as a single wedge but with two different colors. Any hints or solutions? |
Thread Tools | |
Display Modes | |
|
|