Hi,

I am building some dashboards using multiple slicers and multiple pivot tables/charts. The charts in question are stacked columns. When I use the slicers to filter various criteria the chart elements do not remain the color I selected.

So lets say I have John (colored red), Doug (colored green), and Hoser (colored blue) as series' in a column chart. I then add a slicer that listed humans and skunk dogs. If I select humans it leaves me with Bob and Doug, but now Bob is blue, and Doug is red. Its quite a bit more complex than that but that is the jist. Actual data is sensitive, but hopefully someone has encountered this and knows the quick and easy fix that is eluding me. Any help is greatly appreciated.