Excel 2003 chart plots wierd on Excel 2007, time value x-axis
 

Hey all, just upgraded. I have a chart with multiple time value series going
out many years, some of the series have data going into the future a while
and some only to the current date. I plot the data up to the current date to
look at performance against target. With the recent upgrade to 2007, the
entire series plots on the x-axis even if I select a subset for the time
values on the axis format dialog box. Is this new behavior in 2007? Or did I
have the axis as category in 2003 and it converted it when I shifted to 2007?
I made this so long ago I don't recall the setup details. Thanks.