Bar Chart Color Formatting Not Sticking When Filtered, Office 2013

[momcaro]

Hello,
I am using a stacked bar chart to make a Gantt chart (https://www.officetimeline.com/gantt-chart-excel). It works great, but I would like to color each bar with a "team" color, depending on who the tasks belong to. I can do all this manually, a bit tedious but no problem (I have ~130 tasks and 6 colors). Here is the rub: the formatting is not sticking; as soon as I filter/unfilter my data, the colors on the bars go haywire. I have looked online and found no solution. Unchecking the "properties follow chart data point for current workbook" in the advanced options seems to have helped a lot of people, but not me...
Thoughts? Am I doomed to not being able to filter?
Thanks!
Caroline

 

[vletm]

momcaro
You should upload at least a sample file,
including clear samples,
what do You would like to see -
before and after 'something'.

 

[momcaro]

I actually *just* found a workaround using this method: https://peltiertech.com/conditional-formatting-of-excel-charts/
But since I have a stacked bars chart, I had to add a series for each color. Seems to be working so far.