Excel 2003 - Charts - Major X ticks and months

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

Hi guys,

Here is an example of some wishful thinking:

I frequently make charts where the "X" axis represents days. It would be
ideal if I could place a tick mark the first of every month. Is there any
way of doing this?

Thanks,
Craig
 
Hi guys,

Here is an example of some wishful thinking:

I frequently make charts where the "X" axis represents days. It would be
ideal if I could place a tick mark the first of every month. Is there any
way of doing this?

Thanks,
Craig
Click to expand...

Craig,

Format The Axis and choose the base unit as days and you will get a
number of options then for maj/minor tick marks

Matthew
 
Hi;

That one was staring me in the face the whole time. I set it to 1 month and
it worked out just exactly as I wanted.

Thanks much,
Craig
 
Back
Top