Home |
Search |
Today's Posts |
#1
|
|||
|
|||
exploded pie chart with background picture
I tried in vain to create an (exploded) pie chart where a background picture would be exploded into slices e.g a 'euro coin face ' (http://www.ecb.int/bc/coins/common/html/index.en.html) exploded into slices representing some percentage values. When I try to insert a picture, the entire coin face is inserted in all slices, resulting in ugly skewed pictures. PS: if that is solvable, I ultimately wanted a pie-of-pie chart. :) -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=391606 |
#2
|
|||
|
|||
I don't know of any way to split the picture in a pie chart, but Andy
Pope has an example of a split banknote: http://www.andypope.info/charts/dollarsplit.htm rvExcelNewTip wrote: I tried in vain to create an (exploded) pie chart where a background picture would be exploded into slices e.g a 'euro coin face ' (http://www.ecb.int/bc/coins/common/html/index.en.html) exploded into slices representing some percentage values. When I try to insert a picture, the entire coin face is inserted in all slices, resulting in ugly skewed pictures. PS: if that is solvable, I ultimately wanted a pie-of-pie chart. :) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Andy also has a split image for a pie:
http://www.andypope.info/charts/pieimage.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Debra Dalgleish wrote: I don't know of any way to split the picture in a pie chart, but Andy Pope has an example of a split banknote: http://www.andypope.info/charts/dollarsplit.htm rvExcelNewTip wrote: I tried in vain to create an (exploded) pie chart where a background picture would be exploded into slices e.g a 'euro coin face ' (http://www.ecb.int/bc/coins/common/html/index.en.html) exploded into slices representing some percentage values. When I try to insert a picture, the entire coin face is inserted in all slices, resulting in ugly skewed pictures. PS: if that is solvable, I ultimately wanted a pie-of-pie chart. :) |
#4
|
|||
|
|||
Thanks Jon! I'm not sure how I missed that.
Jon Peltier wrote: Andy also has a split image for a pie: http://www.andypope.info/charts/pieimage.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Debra Dalgleish wrote: I don't know of any way to split the picture in a pie chart, but Andy Pope has an example of a split banknote: http://www.andypope.info/charts/dollarsplit.htm rvExcelNewTip wrote: I tried in vain to create an (exploded) pie chart where a background picture would be exploded into slices e.g a 'euro coin face ' (http://www.ecb.int/bc/coins/common/html/index.en.html) exploded into slices representing some percentage values. When I try to insert a picture, the entire coin face is inserted in all slices, resulting in ugly skewed pictures. PS: if that is solvable, I ultimately wanted a pie-of-pie chart. :) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Hi Guys,
Unfortunately the pie image work around will not cope with explosions as it uses a dummy series with a single point to hold the complete image. I think I would switch to using a bank note and bar chart. Cheers Andy Jon Peltier wrote: Andy also has a split image for a pie: http://www.andypope.info/charts/pieimage.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Debra Dalgleish wrote: I don't know of any way to split the picture in a pie chart, but Andy Pope has an example of a split banknote: http://www.andypope.info/charts/dollarsplit.htm rvExcelNewTip wrote: I tried in vain to create an (exploded) pie chart where a background picture would be exploded into slices e.g a 'euro coin face ' (http://www.ecb.int/bc/coins/common/html/index.en.html) exploded into slices representing some percentage values. When I try to insert a picture, the entire coin face is inserted in all slices, resulting in ugly skewed pictures. PS: if that is solvable, I ultimately wanted a pie-of-pie chart. :) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
I managed more or less to fake an exploded pie chart by combining two of andy's chart techniques: 1. I padded the data with a constant spacing value (cfr. split pound note image), the value of which was slightly less than the least real data value 2. I borrowed the procedure from the pieimage chart After the pie with coin background image was created, i changed the filling for the padding data to the same as the chart background color. (I also had to change border color and thickness) Afterwords I deleted the padding labels. The resulting chart looked like am exploded pie - exploded a zero distance from the centre Thanks to all contributers: andy, debra, jon. -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=391606 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a picture fill in my pie chart? | Charts and Charting in Excel | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Background Picture OR text over a picture | Excel Discussion (Misc queries) | |||
How can I print an excel chart so a picture is not distorted? | Charts and Charting in Excel | |||
Chart with Colored Background - Log Log Scale | Charts and Charting in Excel |