I want to change this macro code to a especifically chart,could someone please help me out.
This macro changes all the charts on the spreadsheet but I want to change to only one especifically chart on the spreadsheet
(Chart 5)
This macro changes all the charts on the spreadsheet but I want to change to only one especifically chart on the spreadsheet
(Chart 5)
VBA Code:
Sub rescale()
For Each cht In ActiveSheet.ChartObjects
With cht.Chart
.Axes(xlValue).MaximumScale = ActiveSheet.Range("AF11").Value
.Axes(xlValue).MinimumScale = ActiveSheet.Range("AF10").Value
.Axes(xlValue).MajorUnit = ActiveSheet.Range("AF6").Value
End With
Next cht
End Sub