I have a stacked bar chart with 3 decimal values. They all add upto 100. I am displaying these values on the bar as data points. But I don't want to show the decimal portion of these values, so I created an expression to Round these values. But when I do that, sometimes the total exceeds 100. How can I change the data point display to the rounded values, but use the actual value while calculating the height(total) of the bar?
Re: Change text format of values only for data points
This is correct. Everything is rounding correctly. The fact that when you add up the numbers being displayed you do not get exact numbers is what happens when you round. Are you suggesting that the bottom bar should display 9,9 and 82? That would be mathematically incorrect and misleading. If you need more precision in your results then add decimal places.