Hourly timeline visualization

Your picture looks like a basic stacked bar chart. I find that a lot of the work of creating charts is arranging the data in the spreadsheet. It's far from final, but here's what I did to get something like your picture.

1) My stacked bar chart needs to know what "time" to start. According to your picture, this is 6:45. In AT245 of Performance, I enter =H235.
2) The length of each stacked bar will be the corresponding duration, so I need to retrieve duration from each table. The first "Pane" stack appears to come from "performance," so I enter =I235-H235 into AT246.
3) The next "Change over" bar is the duration from row 390 of DT, so I enter =DT!G390-DT!F390 into AT247.
4) Continue the process of manually pulling durations from the appropriate table into AT248:AT251 until all of the appropriate durations are copied into this range of cells.
5) To create the chart, I simply select AT246:AT251 -> Insert chart -> Stacked bar chart. If necessary, I execute "switch row/column." Then format chart elements as desired.

At this point, the hardest part of creating the chart is compiling the necessary start time and durations from the different source tables. I'm not sure how you intend to interact with these spreadsheets, but my main recommendation is to look at your source data and how you are manipulating everything and find a better way to combine the two tables into one table with the data arranged so your start time + durations will be easier to work with. Without knowing how you create these two tables and how you interact with them, I cannot make any specific suggestions towards that goal.

I'm usually optimistic that most things (like combining two tables into one) are possible (unless my boss tells me that I am forbidden from combining them). What would prevent you from combining the two tables into one?

In order to create the stacked bar chart you show, we must somehow combine the necessary information from the two tables into one. I've shown what the final table needs to look like (we need a contiguous range of cells with start time at the top/left and durations going down/right). If we can get a table that combines the two sources into one with that kind of arrangement, then it will be easy to create the stacked bar chart. If we are not able to combine the two tables into one, then our task of creating the stacked bar chart is more difficult.

What do you think? What are our hurdles to combining the necessary information from the two tables into one table that the chart can use?

Moved to the VBA section at the OP's request.

What if we combined a copy of the data into a single table while leaving the existing tables intact? Would that be allowed?

this needs the data entry to reformat or combine the data on daily basis, tbh i was looking for a simpler way for the user.
but its ok lets try

I'm sure that VBA can help. I would expect that Power Query would be a better programming language, since it is specifically designed for reading, filtering, and shaping data. Regular worksheet functions (lookup functions and such) could also be used. At this point in my understanding of the process, it is less about which programming language to use and really understanding the data extraction/lookup/filter/etc. process that is needed. Your example picture in the OP shows the result for only one production line, but your data include multiple production lines with lots of different possibilities.

Thread closed. The OP has chosen to ask the question in the Commercial Services section. Apologies to those who have invested time in trying to help him.