View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] lilydelaney@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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