Extending Timeline on Gantt Chart

Hi,

Can anyone help me extend the timeline shown on the attached.

It currently shows 56 days at a time which work well for smaller projects but I could do with one that shows 124 days too for larger projects.

Originally Posted by ORoos

Hi there,

I have extended the chart to around 124 days....
Basically just select table (incl header) in the last column and pull to the right.
In row 4 the formula is in every 7th cell. Copy the last one and past every 7th cell.

I have also simplyfied the conditional formatting for row 4 to alternater colors between even and odd month.

Let me know if I missed anything.

Brilliant thank you very much!

That all makes sense, I've just made one for 6 months too just in case and all worked fine. Thanks again!