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