Graph question

[Mr930]

I have a simple X-Y graph with my X being dates. The dates are always end of month days, 1/31, 2/28 etc. Is there a way to get the graph to show the gridlines and tick marks on these dates instead of some arbitrary number based on its automatic scaling? I know I can force an increment since the increment between months is always different.

thanks
Fred Emmerich

 

[RomulusMilea]

Hello,

I have created a very simple column bar graph, based on your assumptions. On X axis I have got end of month dates, and for values axis I have chosen ramdom values, such as 2, 3, etc.

X values are given by following formula, starting in any row, column B, column C, and so on:

=TEXT(DATE(2011,COLUMN(),0),"d-mmm-yyyy")

If you do the same, your graph will display on X axis end of month dates, as you wish. The "secret" is TEXT function. All the best.