Microsoft Excel Project Timeline Template date range errors

Copper Contributor

I'm working with the stock project timeline template in Excel.  For some reason when I put my dates in for start and end, they are not translating to the chart correctly.  For example, a milestone that is supposed to go from 9/19/22 to 9/30/22 is showing up in the chart as starting on the 9/24/22.  Also it is not showing September on the bottom of the chart similar to how October shows up.  How do I 

8 Replies

@Jcahill605 "...the stock project timeline template in Excel." Which one would that be.

@Jcahill605 This one?

Screenshot 2022-09-12 at 07.20.34.png

Entered the dates you mentioned for Milestone 1. Seems to work just fine.

Project Start 9/12/2022
Data Gathering and Review 9/12/2022 10/14/2022
Board and Executive Interviews 9/19/2022 9/23/2022
Financial Analytics 9/12/2022 10/30/2022
SWOT Analysis/Challenge 9/26/2022 10/7/2022
Current State Finalization 9/12/2022 10/14/2022
Cross Functional Review 9/19/2022 9/30/2022
Strategic Alignment Analysis 9/19/2022 10/14/2022
Competative Review and Assessment 9/12/2022 10/28/2022
Future State Co-Development 11/1/2022 11/30/2022
Strategic Plan - Blue Print 10/17/2022 11/30/2022
Phase 1 Complete 12/5/2022 12/5/2022
Yes, dates don't come out right on the chart, nor do we see September as the title on the bottom Axis for the first month.

@Jcahill605 Can't really tell. Why don't you share your file. Attach it here or via Onedrive or similar.

File sent via messenger to you. Any luck opening it?

@Jcahill605 I did and answered you.

Something has messed up this template. The lines are inconsistently formatted, some of the dates are linked to todays date and more. I would go find another Gantt chart template, if I were you.