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?