Changing chart property through macro

Hi everyone,

I'm pretty new to programming in Excel, and I'm facing a challenge. I'm having trouble changing a chart property through a macro which is run by a button.

The issue seems to be that when I press the button to run the macro, it doesn't seem to be able to identify the chart, even though it appears to have the name "Chart 1" that I try to reference it by. I get error "Run-time error 9, Subscript out of range". I'm posting an image below of the macro and the chart.

macro_image.png

Note: I'm trying to change "Axis value" under the "Vertical axis crosses" section of "Axis options" through the macro, since it will be taken from a cell that may change in value.

Any help is greatly appreciated

Thank you very much, that solved it :D