ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pie-of-pie chart issue (https://www.excelbanter.com/charts-charting-excel/162969-pie-pie-chart-issue.html)

Baby Face Lee

Pie-of-pie chart issue
 
I've used some pie-of-pie charts and would find it helpful if the sub-pie
would start from 12 o'clock each time but it seems to start from a random
spot in all cases. Is there a work round for this?
Thanks guys,
Lee

Andy Pope

Pie-of-pie chart issue
 
Hi,

There does not appear to be a way to control the angle.
It is not random though, the angle of the first slice in the second pie
matches that of the lower part of the Others category.

If you want complete control you would need to overlay 2 charts in order
to mimic the pie of pie chart. This may help with that.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

Baby Face Lee wrote:
I've used some pie-of-pie charts and would find it helpful if the sub-pie
would start from 12 o'clock each time but it seems to start from a random
spot in all cases. Is there a work round for this?
Thanks guys,
Lee


Baby Face Lee

Pie-of-pie chart issue
 
Thanks for the reply Andy. I'll have a go at mimicing a pie-of-pie as
suggested.

"Andy Pope" wrote:

Hi,

There does not appear to be a way to control the angle.
It is not random though, the angle of the first slice in the second pie
matches that of the lower part of the Others category.

If you want complete control you would need to overlay 2 charts in order
to mimic the pie of pie chart. This may help with that.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

Baby Face Lee wrote:
I've used some pie-of-pie charts and would find it helpful if the sub-pie
would start from 12 o'clock each time but it seems to start from a random
spot in all cases. Is there a work round for this?
Thanks guys,
Lee




All times are GMT +1. The time now is 05:56 PM.

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