Timeline chart data will not accurately populate

The purpose of this spreadsheet is to have a project timeline of different milestones where I am able to view the progress or the date something was completed in the project. The issue that I am having is that the version that I have now will not go past 1/2015 and when I try altering it to include more months it messes up the timeline that was created . I would like to be able to change the dates when necessary. So if the start date does not start in October and end in June I would like to be able to just change the date and all the information flow.

I have attached the spreadsheet. The timeline and calc2 page that is available to be viewed is the one that won't go past 1/2015. The other project timeline and calc tab is hidden and has the additional dates included but with an altered timeline view.

Hi noboffinme,

In the one that you are looking at no. There is another sheet in the workbook where I include dates past 1/2015 but my timeline chart would not work properly. That's where I am stuck at. I updated the dates and still was unable to get the data retrieval that I was looking for.

The data is listed under the calc worksheet. It may be hidden but there are two calc worksheets.