Ok. I've been beating my head against my keyboard trying to figure this one out and that hasn't been helping.
I have a pivot chart that has a few hundred Assets with volumes gathered every month. Several slicers help me zero in on various factors. However as I adjust the slicers and asset get filtered out, all of my line colors adjust. The first asset on the list is always blue, the second is always orange and so on...
Ideally, I'd like the line for each asset to be constant. Ie Asset 20 is always blue, Asset 21 is always Red, etc... And if there is any way that I dont have to set each color individually, that would be amazing (as I said, there are a few hundred assets in the actual spreadsheet).
Each asset has its own ID#, just in case that might help.
I've uploaded an example of what I have so far. Any help would be greatly appreciated!
https://www.excelforum.com/attachmen...1&d=1492755601
Thank you.
Bookmarks