Hi Mynda,
How do you permanently assign a specific color to an Individual or Item as you did in Lesson 5.03?
I have to allocate all data in my charts to correspond with a specific Waste Steam eg: General Waste is "Green", Office Waste is "Yellow" etc.
This lesson would best suit my dashboard, however it would be more effective if I allocate the specific colors to each Waste Stream.
Thank you
Charmaine
Hi Charmaine,
Select each series one at a time and change the fill colour. Excel will then remember the colour for that series. Note: this doesn't work with Pivot Charts.
Mynda
No wonder I'm having problems
. Is there any way to get around this in a Pivot Chart?
Thank you
You can try removing all filters and then setting the colours (try doing this for just 3 series) then apply the filters via the Slicer to check that they stick before completing it for all. It may work, but it doesn't always.
Mynda
