Using VBA to change axis on a chart

[raza_m33hdy]

Hi all,

I'm trying to use VBA to adjust the axis of a chart, setting a MIN and MAX value and an axis value for the vertical axis crosses. My code is as follows

Please Login or Register  to view this content.

With this code, I can see the values change in the command bar however it is not applying the change to the chart? My chart is called Chart 18

Picture1.jpg

Many Thanks

[Andy Pope]

You will need to post example file as we can not tell exactly what is happening from a picture.

Assume the chart object is correctly named as that would through an error.
Is that axis the Primary horizontal axis?

How are you running the macro?

[raza_m33hdy]

The name of my chart was incorrect (lol)
Sorry. Thanks for the suggestion!!!