So I tried to research this online and found loads of vba to set all the settings and thought my cut down version below would work, and it didn't!
I keep getting a system error &H80070057 (-2147024809)
Sub ScaleAxes()
Worksheets("PM and Programme view").Select
ActiveSheet.ChartObjects("Chart1").Active
Chart1.Axes(xlCategory, xlSecondary).MaximumScale = Range("AG26").Value
End Sub
If anyone can help to resolve this that would be great!
Thanks
I keep getting a system error &H80070057 (-2147024809)
Sub ScaleAxes()
Worksheets("PM and Programme view").Select
ActiveSheet.ChartObjects("Chart1").Active
Chart1.Axes(xlCategory, xlSecondary).MaximumScale = Range("AG26").Value
End Sub
If anyone can help to resolve this that would be great!
Thanks