I have a chart where the y-axis represents a number which will only ever be whole numbers. If, when the report is run, the maxiumum value happens to be a low number such as 2, then the y-axis increments in steps of 0.5. I've attached an example.
Is there a way to force the axes to increment in whole numbers only?
I've played around with the Range Inflate settings, but to be honest I don't undestand what effect they are supposed to have.