X Axis Interval Problem

[StuFromSaturday]

Good afternoon/evening/morning all - I wonder if anyone can help?

I have a fairly simple line chart with monthly (end of the month) datapoints, from 30/04/2006 - 31/05/2011. However, on the x axis all I want to see are the quarterly datapoints, i.e: 30/06/2006, 30/09/2006, 31/12/2006, 31/03/2007 and so on.

I've hunted high and low with no success....can anyone help???


Stu

 

[pbornemeier]

In the source data for the graph, replace the dates you don't want to see with a space.

 

[tusharm]

No need to destroy your data. {grin}

Assuming your dates are dates as Excel understands them...

Right click on the horizontal (X) axis, then select Format Axis... | Axis Options tab | set Major Unit to 3 months.

Good afternoon/evening/morning all - I wonder if anyone can help?

I have a fairly simple line chart with monthly (end of the month) datapoints, from 30/04/2006 - 31/05/2011. However, on the x axis all I want to see are the quarterly datapoints, i.e: 30/06/2006, 30/09/2006, 31/12/2006, 31/03/2007 and so on.

I've hunted high and low with no success....can anyone help???


Stu

 

[StuFromSaturday]

Easy when you know how, eh??! Thank you so much guys. Beer owed.


Stu