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.
Bookmarks