Excel 2007 : Excel 2007 Chart adding dates to X-Axis which are not in selected data range

I'm in the process of converting a workbook from the 2003 version of Excel to the 2007 version as we're in the middle of upgrading our office. Our workbook was working perfectly until I converted it to the *.xlsx version.

Our preference is to be able to use some of the new features of the 2007 version of Excel. So now I am in need of recreating the workbook from scratch. I'm ok with it as I can now clean it up a bit and make full use of the 2007 feature set.

I've done some Google searching and can't find anything about this problem that I am experiencing.

I have a worksheet within the workbook that has 2 weeks of dates, actually 9 working days in it and they are setup across the columns, E6 through M6.

Day #1 is 2/2/09 (E6)
Day #9 is 2/12/09 (M6)

The data being charted is in E7 through M7

2/7 and 2/8 are obviously a weekend and therefore are not included in my data in the worksheet.

I'm now charting the data for this period of time and the chart is including 2/7 and 2/8 on my X-Axis of the line chart even though they are not included in the data contained in E6 through M6. Is there a way to not have the chart add these 2 dates to the X-Axis? What am I missing?

It makes the chart an eye sore to look at.

Thanks in advance for any assistance.

Chris

When using dates as the x axis labels excel turns the axis in to a Time series rather than Category axis.
To get a Category axis in xl2007 select the x axis. CTRL+1 to display Format dialog. Axis Options section has a Axis Type setting, which should be Text.

stalinsamuel,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.