EXCEL 2007

If I set things up exactly as you state I get the right days along the X
axis.

My underlying data for the dates I set up as Custom Format dd-mmm-yy. Maybe
if you set things up this way you will get the right dates appearing in the
chart?

If my comments have helped please hit Yes.

Thanks.



"excel_slave" wrote:

I am using a time-value x-axis. My minimum point is 10/31/08 and my maximum
is 10/31/11. I have the base unit as days and the major unit interval set as
months. In Excel 2003, this gave me axis labels of 10/31, 11/30, 12/31 etc.
In 2007 it gives me 10/31, 12/1, 1/1 etc. - I cannot figure out how to make
it show the labels as of the last day of the month instead of the first day
of the next month.