I have an xy scatter chart, which is plotting info for 3 different series.
My end date is 2006, yet the X axis shows an end date of 2008. I have not
plotted any data for 2007, or 2008. The years appear on my x axis with no
info plotted on the y axis.

Any ideas how to adjust to reflect just up to the actual date of 2006?

Thanks,
Alicia