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.
Bookmarks