Using Gantt chart template in Excel

Question

Hi

I have downloaded a date tracking gantt chart template in Excel and I'm trying to figure out why the number of days I have input into the project area is not reflected in the calendar portion.  If I input 10 days, I get 8 showing in the calendar.  Also, the start date shown in the calendar is never correct, it's always 1 day after the start date stated.  The formula I get when I click in the calendar is 

=IFERROR(IF(LEN(Milestones[@[No. Days]])=0,"",IF(AND(H$5=$E11,$F11=1),Milestone_Marker,"")),"")

Can anyone tell me what this is saying and what I need to do to amend it so that the right number of days will show please?

Thanks

Answer 1

Hi Rachel,

I have done more research and found the below temlplate provided by third-party which might meet your daily use. Currently, I'd like to suggest using it as a possible workaround.

https://plan.io/blog/gantt-chart-excel-template/

Disclaimer***:** Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.* 

Meanwhile, regarding the template Microsoft provided, I'd like to suggest opening Excel, clicking File > Feedback to submit your feedback. It is the direct way to initiate the related team to know about it and do some adjustments.

Regards,

Tina

Answer 2

Hi Rachel,

I had the same query about the Date tracking Gantt chart template. Looks like it is designed to display the bars from day 2 - penultimate day (not sure how this is useful for anyone!).

You can change the bar display if you click on the bar chart then go to Conditional Formatting (under Home), -> manage rules -> select the rule that governs the bar colouration (brown fill in the template I am using) then click "edit rule".

You will see this formula: =AND(H$5>=$E7+1,H$5<=$E7+$F7-2)

Change it to this formula: =AND(H$5>=$E7,H$5<=$E7+$F7-1)

This will change all of the bars to display as many cells as days in your "No. Days" column, commencing on the date you insert in the "start" column.

Milestone markers will appear i the same cell as the last day highlighted - I am sure you can change this if you prefer as well, just haven't played around with that bit yet.

Regards,

Sarah

Answer 3

Hi Rachel,

Thanks for the query. For all the members to easily check the query with more intuitive environment, here is the template in question https://templates.office.com/en-US/Date-tracking-Gantt-chart-TM22588720. We can also click New to search for date tracking gantt chart to get it.

Based on my test, I can reproduce the same result on all channels. To involve more resources to further investigate the issue, could you please go to File > Account > Product Information to share with us a screenshot of your Prodcut Information. 

Note please mask your email address to protect your privacy.

Regards,

Tina