ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pie Chart with other charts representing each slice (https://www.excelbanter.com/charts-charting-excel/172592-pie-chart-other-charts-representing-each-slice.html)

Tammy

Pie Chart with other charts representing each slice
 
Hello,

I wasn't sure where to start researching this, so I'm starting here.

I have a user who would like to create a pie chart representing totals. She
would then like to have "offshoot" charts indicating the values used to
arrive at the total for each slice. These separate charts should be
positioned next to each slice it represents.

Can Excel do this automatically, or will she have to create charts for each
slice separately?

We are using Excel 2007.

Thanks for any suggestions - please let me know if more detail is needed.

Andy Pope

Pie Chart with other charts representing each slice
 
Hi,

Nothing built-in, you will have to create the compound chart yourself.
See Jon's variation using pies.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tammy" wrote in message
...
Hello,

I wasn't sure where to start researching this, so I'm starting here.

I have a user who would like to create a pie chart representing totals.
She
would then like to have "offshoot" charts indicating the values used to
arrive at the total for each slice. These separate charts should be
positioned next to each slice it represents.

Can Excel do this automatically, or will she have to create charts for
each
slice separately?

We are using Excel 2007.

Thanks for any suggestions - please let me know if more detail is needed.



Tammy

Pie Chart with other charts representing each slice
 
Thanks so much for the info., Andy!

"Andy Pope" wrote:

Hi,

Nothing built-in, you will have to create the compound chart yourself.
See Jon's variation using pies.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tammy" wrote in message
...
Hello,

I wasn't sure where to start researching this, so I'm starting here.

I have a user who would like to create a pie chart representing totals.
She
would then like to have "offshoot" charts indicating the values used to
arrive at the total for each slice. These separate charts should be
positioned next to each slice it represents.

Can Excel do this automatically, or will she have to create charts for
each
slice separately?

We are using Excel 2007.

Thanks for any suggestions - please let me know if more detail is needed.




All times are GMT +1. The time now is 03:56 AM.

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