This works just fine in 2003. If you use a base unit of days, a major unit
of 1 month, and a minimum scale value of the last day of a month, then the
axis has a tick at the last day of each month.

In 2007 it doesn't work.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Lori" wrote in message
...
Having difficulties creating a line chart using daily balances, but I
would
like the x-axis to show the month-end date. My start date is 12/31/2007
and
my end date is 6/30/2008. I have daily information that I would like
plotted, however only the month-end date (1/31/2008, 2/28/2008, etc) to
show.


I have experimented with the axis options (day, month, year), however it
seems to default to the 1st day of the month. If using every 30 days, it
also becomes off.

Please help. I'm using an existing chart from Excel 03, and it will not
convert properly...I've also tried creating a new chart from scratch.

Thanks,
Lori