I have been working with multiple axis charts and I was wondering how to get the tics to align with the grid lines without explicitly setting the minimum and maximum values for the axes. I can get the grid lines to align for one axis but not both when I allow the axes to auto-adjust their scales. For example, here is a chart I have:
And I want the grid lines to line up with 160, 140, 120, etc. not just 20, 18, 16 etc.
The reason I want to keep the auto adjustment is because the data can change when the same chart reloads so the axis min and max may change as well.