Okay, I think I see what you are trying to do. You want to ignore the year
so you that you can plot multiple years on the same scale. Unfortunately
there isn't a way to ignore the year. Excel only understands dates to be
calculated as the number of days from January 0, 1900 plus a fractional
portion of a 24 hour day. This is called a serial date.
You could make a copy of your data and set all the years to the same so they
can be plotted on top of each other, and Excel can be smart about placing the
dates in the right place along the x-axis.
Create an XY scatter plot from just your 2004 data and date labels.
Then, change the year on all your 2005 and 2006 date labels to be 2004 also.
In Source Data dialog from the chart, add a series and select the "fake"
2004 label range for x-axis the the 2004 data range for the values. Add
another series and do the same for the "fake" 2005 series x-axis labels range
and data range for the values. Make sense?
You can't have only a month and day in cell without the year, Excel will
think that is just text.
You also might be better off just creating 3 charts (one for each year) next
to each other which would be more flexible and accurate.
--
Thanks,
Christopher
This posting is provided "AS IS" with no warranties, and confers no rights.