Dynamic colors for excel gantt chart

Hi All,

1. Need to create chart (Gantt) in Excel for filling machine schedule in my factory. Filling machine schedule is changeable from day to day (DAY 1, DAY 2); bat the steps are the same. Only deference is steps order in the filling machine schedule. Any way, I need that color in the chart be the same for every each step no meter on the step (series) position in the schedule. Off corse charte shood be automatically filled whenever I change the schedule.
For example, “Tomato sauce” on the “DAY 1.” is on the 7. position, and on the :DAY 2” on the 2. However, the color that represents “Tomato sauce” (Red) in the chart is the same for bouthe days. In other to represent my problem better I did it manually (see attached file – Tab Question 1.)

2. Also need to edit “Data serias PopUp” (Question 2). The default settings presents only “Serias”, “Point” and “Value”. In addition to that I need values for time that each step starts (From) and time that each step ends (To). In other to represent my second question better I did a little drawing (see attached file – Tab Question 2.). Thus I manually draw PopUp with requested data for “Lemon juice” data serias. Also I did calculate values for “Lemon juice filing Start” (From) and “Lemon juice filing Start” (To).
Thanks in advance…

Bump no response