Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site

Have Excel Pie Charts Always had duff rounding?

Straight answers to factual questions
Forum rules
Direct questions and answers, this room is not for general discussion please
Clariman
Lemon Quarter
Posts: 3277
Joined: November 4th, 2016, 12:17 am
Has thanked: 3106 times
Been thanked: 1559 times

Have Excel Pie Charts Always had duff rounding?

#243769

Postby Clariman » August 12th, 2019, 2:54 pm

I've worked with Excel and other spreadsheets for decades but have never noticed that the % figures of each segment in a pie-chart are rounded up? So I'm looking at data where the 2 metrics I am focusing appear 54.4% and 33.3% of the time, but the labels on the pie-chart show 55% and 34%. So rounding to nearest integer would give me a combined 87% (or 88% when the summed decimal place gets rounded) versus 89% in the pie chart. That's not really good enough.

Is it possible to get Excel 365 to display % to one decimal place in a pie chart?

Thanks
C

Clariman
Lemon Quarter
Posts: 3277
Joined: November 4th, 2016, 12:17 am
Has thanked: 3106 times
Been thanked: 1559 times

Re: Have Excel Pie Charts Always had duff rounding?

#243770

Postby Clariman » August 12th, 2019, 2:57 pm

I've just worked it out. No worries.


Return to “Does anyone know?”

Who is online

Users browsing this forum: No registered users and 7 guests