I notice that the "axis minimum" for the horizontal axis is set to automatic. So, when you add more dates, or get a different date range, Excel will "choose" the axis min and max based on its built in, default algorithm. If you want something other than the default min and max values, you will need to go into the "format axis" dialog and tell Excel what you want to use for the axis min and/or max.