Hello,

I have some problems to change parameters in my chart via VBA.
I have a Chart on my sheet, I can select it and I want to change the X axis scale.

I used :
With ActiveChart.Axes(xlCategory)
.MaximumScale = 16000
End With

It gives me an error saying that "MaximumScale" is not from the Axes Object.
I can change the Y axis by doing the same thing but replacing xlCategory by xlValue.

I am not sure how it works but the code with "xlCategory" did work for other charts.
Is it different for the histogram chart ?

Anyway, I would like to change the X axis scale, can someone help me please ?

Thank you very much in advance.