Gantt chart - won't display data prior to todays date

Hello.
I would really appreciate someones help / expertise in resolving an issue I have with an excel gantt chart. It's setup to show days to start, start date, completion, end date and slippage. Unfortunately, in getting the days to start to display correctly, everything runs from today(). When a task start date falls before today, it is effectively deleted from the chart. I have no idea how to fix this! Please help!

I've copied a picture below. You'll see that task D in the first section is only showing from today's date despite starting on the 10th March.

Any help would be appreciated,

Thanks

Jonathan
gantt.png

Thank you for the quick response. It won't let me attach the file unfortunately, nor paste a link to the file until I have posted a few times.



Column H is =today() formula yes. When I change it to the project start date, the stacking doesn't work (the activities appear to start early), nor the days to start.

Thank you again!

ps. if it lets me reply with a link after this, I shall.