Yearly tick marks on the x axis

[Guest]

How do you show tick marks each 12 months in a graph when the data is from month 1 to say month 60. If you say want a tick mark each 12 th division you have 1,13,25,37 etc. You can't start from zero so how do you do this

I'm using Excel 2002

Thanks
Ken G

 

[David Benson]

Ken,

I tried this using a Line chart (as opposed to an XY, or Scatter, chart) and
it worked fine. I defined the x-axis as a range containing the numbers 1 to
60, and the y-axis the adjacent cells in the next column. Double clicking
on the x-axis to open the Format Axis dialog, I selected the Scale tab. The
first box (Y-axis crosses at category number) was already set to 1. I
entered 12 in the other two boxes (Number of categories between tick-mark
labels and Number of categories between tick marks) and got a graph with
labels at 1, 13, 25, 37, and 49.

-- David

How do you show tick marks each 12 months in a graph when the data is from

month 1 to say month 60. If you say want a tick mark each 12 th division you
have 1,13,25,37 etc. You can't start from zero so how do you do this?

 

[Guest]

Yes David, that what I got, but what I want is tick marks/labels at 12,24,36,48 etc signifying years. In reality the first mark should be 1 +11 and then each subsequent mark should be + 12. How do you show this?

 

[Jon Peltier]

Ken -

If it's a line chart, put only the numbers you want to show into the X
values column, and leave the other cells blank. In other words, only put
the number in the cell for 12,24,36, etc., then make sure Excel is using
this range for category labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______