Custom excel interval size? Possible or not?

[dinosaur_uk]

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

[dinosaur_uk]

I guess not then

back to using labels

[Siddharth Rout]

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

[westconn1]

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

[dinosaur_uk]

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

[westconn1]

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

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

[anhn]

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

[dinosaur_uk]

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