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
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?
Forum rules
Direct questions and answers, this room is not for general discussion please
Direct questions and answers, this room is not for general discussion please
-
- Lemon Quarter
- Posts: 3277
- Joined: November 4th, 2016, 12:17 am
- Has thanked: 3106 times
- Been thanked: 1559 times
-
- Lemon Quarter
- Posts: 3277
- Joined: November 4th, 2016, 12:17 am
- Has thanked: 3106 times
- Been thanked: 1559 times
Who is online
Users browsing this forum: No registered users and 7 guests