Sub QvAuto()
Dim ch As ChartObject
Set ch = Sheets("Courbes").ChartObjects(1)
ch.Chart.Axes(xlCategory).MaximumScaleIsAuto = True
'ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Sub QvPlus()
Dim ch As ChartObject
Set ch = Sheets("Courbes").ChartObjects(1)
ch.Chart.Axes(xlCategory).MaximumScale = ch.Chart.Axes(xlCategory).MaximumScale + 1000
'ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Sub Qvmoins()
Dim ch As ChartObject
Set ch = Sheets("Courbes").ChartObjects(1)
ch.Chart.Axes(xlCategory).MaximumScale = ch.Chart.Axes(xlCategory).MaximumScale - 1000
'ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub