Anybody have any ideas on setting up a pie chart with 26 slices of descriptions other than combining the descriptions? 86% is undefined but I have 25 other tiny slices to show.
Microsoft PowerPointMicrosoft OfficeMicrosoft Excel
I thought about that but I'm not sure it's appropriate for this chart - it shows reasons for loss so 86% is unspecified and the rest have reasons - also won't the percentages be skewed?
error_prone
ASKER
What I mean is that the breakout is not a subset of something, like it is in the example you have, they're all the same metric - reasons for loss.
Cornelia Yoder
I would make the main pie chart have 2 sections, the one you will breakout should have a generic caption, like "Loss" (or whatever's appropriate).
Then the breakout section can detail the reasons for loss. Put the correct percentages on the breakout, so it totals up to the same 24% as the pie section for Loss.
"Put the correct percentages on the breakout, so it totals up to the same 24% as the pie section for Loss."
That's what I tried before and got stuck. How do I set up the seperate percentages and set it up so it updates automatically and so it references the right percentages?