Excel 2003 - Charts - Major X ticks and months

[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

 

[Matthew]

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

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