Changing scale axis

VBA is the only way as you can not directly link scale values to cells.

Something like this will do it for the Value axis

    With ActiveChart.Axes(xlValue)
        .MinimumScale = Range("A1")
        .MaximumScale = Range("A2")
    End With

There is a little more to it than that.

You would need to wrap the code in a procedure.
Then select the chart and run the macro

Sub ChangeAxis()

    With ActiveChart.Axes(xlValue)
        .MinimumScale = Range("A1")
        .MaximumScale = Range("A2")
    End With

End sub

Or you could add code to the worksheet change event so the code is run when the cells containing the information are altered.
See attached.

Included in this is a change to the procedure so the chart to be altered is passed as an argument rather than relying on the active chart object

Yes. The routine would need to know which sheet to check.

So I have added the min and max values to the argument list.

Sub AxisChange(Cht As Chart, MinValue, MaxValue)
    With Cht.Axes(xlValue)
        .MinimumScale = MinValue
        .MaximumScale = MaxValue
    End With
End Sub

And the sheet level code can pass the relevant information

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Range("A1:A2"), Target) Is Nothing Then
        AxisChange ActiveSheet.ChartObjects(1).Chart, Range("A1").Value, Range("A2").Value
    End If
    
End Sub