I am working on a WebI report where a bar chart is being used to display an average. The numbers are sometimes going to be between 0 and 2 (and sometimes 0 and 50+), but we would like them rounded to a whole number (so lots of zeros and ones). I can make the chart do this. However, when the values are [0,2], the chart's Y-axis displays decimal values (0, 0.4, 0.8, 1.2, 1.6 and 2). I change the y-axis format to be whole number, and then what happens is I get a lot of 0 and 1 values for the y-axis (so the y-axis displays 0 0 1 1 1 2 rather than just 0 1 2). It appears that the y-axis is just rounding the values...
I have tried messing with the auto axis value frequency and the frequency itself. I also have tried auto-scale as well. I have tried pretty much every posible combination of settings inside the format chart.
Is there a way to fix this?