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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Charting Legend
- Thread starter adrainou
- Start date
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
