Page 1 of 1

Have Excel Pie Charts Always had duff rounding?

Posted: August 12th, 2019, 2:54 pm
by Clariman
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

Re: Have Excel Pie Charts Always had duff rounding?

Posted: August 12th, 2019, 2:57 pm
by Clariman
I've just worked it out. No worries.