Hello
I have a pivot chart (stacked column) that has a branch & date fields on the
x axis with a product type in the legend.

problem is that i dont have a consistent color for the one product.

the color scheme seems to depend on the number of products at each branch.

i want to ensure there is only 1 colour per product on the bar chart no
matter how many products a branch may sell

how can i fix this please.