Custom scale in chart

[slashiiboy]

Hi everybody, I am trying to customize my "x" axis in a chart, this axis contains years and "y" axis contains the number of events. So what I am trying to do is to start my "x" axis in the year 1904, then the next year should be 1910, 1920, 1930.....2013. I must use this specific interval, it must start in 1904, the next value 1910 adding 10 years at a time till 2013 exactly. I've been trying with this VBA code:


Sub ScaleAxes()
With Application.ActiveChart.Axes(xlCategory, xlPrimary)
.MinimumScale = ActiveSheet.Range("t3").Value
.MaximumScale = ActiveSheet.Range("t15").Value
.MajorUnit = ActiveSheet.Range("t17").Value
.DisplayUnit = ActiveSheet.Range("t15").Value
End With


End Sub


But this only helps me to set the minimun and maximum I am still trying to figure how to start the sum in 1910.... The final scale should look like this:

1904,1910, 1920.....2013

THANKS IN ADVANCE

[p45cal]

Supply a file with your chart and its data for us to experiment with - it'll answer quite a lot questions about how you've set it up.

ps. Finding this difficult in Excel 2010 with an xy scatter chart so far… What's your version of Excel and are those years actual Excel dates in the sheet?

[mdmackillop]

Must the X axis spacing be proportionate? Have a look at this

[p45cal]

You can do something like this but it's not especially easy:
Attachment 19456

[Aussiebear]

@Slashilboy.... posted this issue anywhere else recently?

[slashiiboy]

foro.jpg
Here is an image of my graph, I hope this will help us to solve the initial problem

[p45cal]

Here is an image of my graph, I hope this will help us to solve the initial problem

Not at all.

1. Supply a file (not a picture of a file) with your chart and its data for us to experiment with - it'll answer quite a lot questions about how you've set it up.
2. Answer the questions that people who are trying to help you ask.
3. In msg#5, Aussiebear asked you about posting elsewhere (you have); please have a read of http://www.excelguru.ca/content.php?184, then post links to those posts.

[Aussiebear]

@slashilboy Since you appear to be ignoring my question, I shall put your thread on hold until you pm me with your responce.