Creating a dynamic stacked bar chart with conditional formating and labels reading from cells

Hi, I have been trying to create a stacked bar chart per TM# for the below that takes into consideration the order of the activities in each line where each category (Manual, Aux,...)is in its separa...