Hi good people!,

I have this code:
Private Sub Worksheet_Change(ByVal Target As Range)
With ActiveSheet.ChartObjects("Chart 5").Chart
    Select Case Target.Address
      Case "$A$2"
        .Axes(xlValue).MaximumScale = Target.Value
      Case "$A$3"
        .Axes(xlValue).MinimumScale = Target.Value
      Case "$A$4"
        .Axes(xlValue).MajorUnit = Target.Value
    End Select
  End With
End Sub
which I got from, I think Mark Peltier's site, but just cannot get it to work. I have a dropdown which selects the criteria I want to view on the chart. The Chart itself works fine, I just need to have the Y-axis scale according to what I am viewing. Please, if someone could shed some light on this for me?