Dude 2 Excel Dude
New Member
- Joined
- Apr 21, 2014
- Messages
- 8
Hi
I would like to keep the same chart colors when using slicers depending on the brand vendor.
However, let's assume my chart has 4 vendors
Vendor A - green bar
Vendor B - blue bar
Vendor C - yellow bar
Vendor D - red bar
If I pick the four vendors it will show the colors mentioned above but if i choose two vendors from the slicer, the colors will change and not maintain the original as when I was picking all four of them.
Is there a way to keep the same color to the desired vendor even if I choose different combinations within the slicer?
Thanks,
D2S
I would like to keep the same chart colors when using slicers depending on the brand vendor.
However, let's assume my chart has 4 vendors
Vendor A - green bar
Vendor B - blue bar
Vendor C - yellow bar
Vendor D - red bar
If I pick the four vendors it will show the colors mentioned above but if i choose two vendors from the slicer, the colors will change and not maintain the original as when I was picking all four of them.
Is there a way to keep the same color to the desired vendor even if I choose different combinations within the slicer?
Thanks,
D2S