Change the major units in X axes in chart(vba)

[backspace20]

I want to change the major units in X axes
I have tried the following code :

With .Axes(xlValue, xlprimary)
.MajorUnit = 30
End With
But it changes y axes

I tried to use
With .Axes(xlValue, xlSecondary)
.MajorUnit = 30
End With

but it is giving me an error.

How can I change the major unit in x axces?

Cheers,

[mancubus]

crosposted:
http://www.mrexcel.com/forum/excel-q...lications.html

please refer to cross posting etiquette