Have Excel Pie Charts Always had duff rounding?
Posted: 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
Is it possible to get Excel 365 to display % to one decimal place in a pie chart?
Thanks
C