Hi there,

I work for a small charity in Scotland and I'm trying to work out a way of keeping track of timelines across a few different regions - seemed like putting together some Gantt Charts was the way to go, but after about an hour of searching on both this website and others I'm not quite finding what I'm looking for. Given the fact it's pretty much a statistical impossibility for me to be the first person to have this issue I'm starting to wonder if the reason I can't find something is because it's not actually possible.

What I am after is the ability to have a table for each region of scotland from which regional Gantt charts are made, but that a 4th "Master" Gantt chart gathers the information from each table to create a "Scotland National" Gantt Chart, organised by date not region. So far this seems possible, but ideally I would want people to be able to add rows to the tables for each region when new things come up, and for both the regional Gantt Charts and the National Gantt Charts to recognise that there has been a change in the data and update themselves accordingly showing the new row and rearranging itself so that things remain in date order.

The issue with this that I keep on coming up against is that the chart requires you to specify the cell range so adding new rows means telling both charts to go look for the extra information, and I'm just aware that there's a good chance people will forget the extra steps and things will be missed.

If there is no way around this then fair enough I'll just have to think of another system. I thought about seeing if I could use an "IF" function to get the chart to look at the next row down in the table and if there is data add another row to the chart but everything I looked at was so beyond my level of understanding that it was akin to trying to teach non-euclidean geometry to 10 year olds.

Before I continue trying to find more on how to make this work I would greatly appreciate the benefit of your greater knowledge as to whether this is even possible. Of course support in how I would build it (maybe with finger puppets and crayons) would also be amazing.

Thank you for taking the time to read this