The x-axis has defaulted to a time-scale. To change the setting:

Select the chart
Choose ChartOptions
Select the Axes tab
For Category (X) axis, choose Category, click OK


Debbie424242 wrote:
Excel is inserting holidays and weekend days into my time series. I want to
stop it doing this and to use only my date series.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html