L
lilydelaney
This question was asked before
http://groups.google.com/group/micr...el+"pie+of+pie"&rnum=3&hl=en#db61897bf78384c7
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
http://groups.google.com/group/micr...el+"pie+of+pie"&rnum=3&hl=en#db61897bf78384c7
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