Changing scale axis

Is there any change when having the chart in different sheet?

Hi Andy. Thx for your wise suggestions. I managed to use all the code you sent including the part for running the code when changing the cells.

I'm not able to use it when the chart is in different datasheet though. I think the problem is in defining the variables MinValue & and Maxvalue as inputs you suggested in the rutine you sent. All the cells are in sheet1 and the chart is within the same book as chart sheet.

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

How should I do that? Is there any modification in here?

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

Thx

Ok, it's a bit more clear!! but still i get an error about the chart objects property when trying to use the values from the datasheet to the chart. what could it be? I attached and example to clarify my question.

Thx

Hi Andy. I've tried everything which is in my hands but i'm not able to find how to find the solution when having the data and the chart in diferent data sheet.

I've got in the main module the following code:

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

Attached to the "data" datasheet this one:

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

And attached to the "chart" datasheet the same code as for the datasheet. I also tried without code in the "chart" datasheet and i made several changes concerning the name of variables (i.e. Sheets("Sheet1").Range("1")) and so on but still I get errors when running it....
Any hint.

Thank you very much.