Custom excel interval size? Possible or not?

Hi there,

I have a question, is it possible to customise the interval size on a chart in excel, let's say the x-axis. Is this possible at all?

cheers

I guess not then

back to using labels

sorry, didn't quite understand the question...

i am sure i have done it in the past, you need to format the axis scale

see if you can do it in the chart, then record a macro to get an idea of the code

erm.. but you cant use a macro to make a custom scale?

if you record a macro of changing the scale you can then modify the code from the macro to put whatever scale you wish

vb Code:

With ActiveChart.Axes(xlValue)
        .MinimumScaleIsAuto = True
        .MaximumScaleIsAuto = True
        .MinorUnitIsAuto = True
        .MajorUnit = 1.5
        .Crosses = xlAutomatic
        .ReversePlotOrder = False
        .ScaleType = xlLinear
        .DisplayUnit = xlNone
    End With

if you change the value of minorunit, maximumscale or minimumscale the isauto property for them will change to false

Give us an example and tell how you want to it.

Thanks for the help, I do know how to change a regular interval too

but i am talking about a irregular scale interval

so for example, i want it to only display 1 , 5, and 42 on the x-axis