I have created a gantt chart using a stacked bar chart and hiding the first
series. The tasks also have a different priority. Is htere a way I can use VB
to change the colour of each task bar depending on the priority. I have 3
prioritys, either high medium or low.

Thanks