I am running 2 pivots off of a slicer in Excel 2010 which is then updating 2 different charts. I have noticed that when I filter by a slicer option it updates the charts as intended. However, the legend is showing by company and when the bar chart updates the color associated with the company isn't always the same. Can I make it where a company is always the same color in the legend?