ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   change %s of second pie in a pie of pie chart (https://www.excelbanter.com/charts-charting-excel/98758-change-%25s-second-pie-pie-pie-chart.html)

[email protected]

change %s of second pie in a pie of pie chart
 
This question was asked before
http://groups.google.com/group/micro...61897bf78384c7
but the link provided as an answer did not answer the question (or I
didn't see where the question was address on that webpage).

Is there a way to make the second pie reflect the percents of that pie
and not the main pie? I need the second pie to equal 100% of the slice
it is coming from. By default, each slice in the second pie shows the
percentage of the main pie. I realize I could just manually change
them all to the values I need, but I wanted to know if there is a way
to change the options so it will happen automatically.

I am using Excel 2003.

I'd appreciate suggestions. Thanks!
-Lily



All times are GMT +1. The time now is 07:53 PM.

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