I have a line graph with two statistics.
Say "Number of Sales" and "Value of Sales".
I can happily code the maximum and minimum scales for the first statistic (Left hand side).
and am using:
Me![Graph0].Object.Application.Chart.axes(2).minimumscale = _
CDbl(Me.Min1) 'Set the minimum scale
Me![Graph0].Object.Application.Chart.axes(2).maximumscale = _
CDbl(Me.Max1) 'Set the maximum scale
But I'm having trouble identifing the second (Right hand side) x axis.
I've tried .axes(3), .axes(4) and .axes(1) and by doing so really messed up the graph.
I got it back again working as before the trail and error testing - actually all error testing.
My question is does anyone know how to reference the second x axis for maximum and minimum scales?
Or where I could go to find out?