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-questions/929232-change-major-units-x-axes-visual-basic-applications.html

please refer to cross posting etiquette