Link to home
Start Free TrialLog in
Avatar of error_prone
error_prone

asked on

Pie Chart with too many slices

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.
ASKER CERTIFIED SOLUTION
Avatar of Cornelia Yoder
Cornelia Yoder
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of error_prone
error_prone

ASKER

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?
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.
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?
SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial