Gantt Chart Question

Hello again everyone,

So I've thrown this together. I can't use proper data but you get the picture...

Sheet 1 Sheet 2 and Sheet 3 are the ones that people would fill out. They contain simple tables where people would type in when something needs to be done by (Column E) and how much time it would take (Column D) and there's a formula in Column C which calculates the start date for the Gantt chart - I'll probably hide column C once all the kinks are worked out.

There are separate Gantts for each of these tables so people can look at just their own stuff if they want.

Sheet 9 is where I'm stumped. I couldn't find any information on pulling together a chart that would treat all the column C's across sheets 1, 2 and 3 as though they were all the same table, so it seemed my only choice was to build a table which amalgamated all 3 tables and make a chart from that one.

The way it's done here is by me just saying "The content of this cell is the content of cell C6 from sheet 3" which is fine if people aren't fiddling with the data but I'd like it to recognise when there's another line added to one of the tables and order it's own data accordingly.

Now sorry if this doesn't make any sense, (I don't really know what I'm talking about) but I thought there would be a variation of a rule that could be put in that tells a cell in the amalgamated chart to look at the cell below the one the cell above it references, and if there is data in that cell to display that data, but if there is no data move to Table 2!B5.

I had a bit of a look around and I found a formula (which I'm not allowed to put in this post for some reason) but I don't have enough base knowledge of what this formula is saying to know how to adapt it to fit my tables.

Any help anyone could give would be utterly amazing.

Hi,

Using a bar chart as you've done is one way but IMO a far easier way is to use conditional formatting and have very narrow columns for each day. You can then have these on the same sheet as your start & delivery dates

See attached where I've added a few examples for February for rows 5:10