Excel 2003 - Charts - Major X ticks and months

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
 
M

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
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
 
Top