ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Take each piece of a pie chart and put on own sheet? (https://www.excelbanter.com/charts-charting-excel/190390-take-each-piece-pie-chart-put-own-sheet.html)

YaYa

Take each piece of a pie chart and put on own sheet?
 
Help! I need to take each piece of pie on a pie chart and put on its own
sheet for a presentation in less than a week. I have had no luck with
copying and pasting and have asked numerous people. Any ideas??? THANK
YOU!!!

Andy Pope

Take each piece of a pie chart and put on own sheet?
 
Hi,

Simplest way would be to create multiple charts, 1 for each of the
slices. And then format all but the slice you wish to display as having
no border or fill.

Cheers
Andy

YaYa wrote:
Help! I need to take each piece of pie on a pie chart and put on its own
sheet for a presentation in less than a week. I have had no luck with
copying and pasting and have asked numerous people. Any ideas??? THANK
YOU!!!


--

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


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com