The grid line intervals and labels for charts in a layout often make no sense to me. For example, here there are grid lines every 1 up to 10, but then they suddenly change to every 2 above that. But the labels are only every two.
Just moments ago, I updated the source data and got the example above. Even though the max of 17 didn't change, it was previously showing the following intervals:
If I jiggle the width of the chart, I get results this, which seem totally nonsensical:
Is there a way to make them some fixed interval or somehow get around this behavior?