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.
Microsoft PowerPointMicrosoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
GlennaShaw

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Cornelia Yoder

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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?
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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
error_prone

ASKER
"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
Rory Archibald

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
GlennaShaw

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.