Hack for color coding bar chart based on multiple series

user03448

Hi there, 

 

I have the bar chart attached that I would like to configure such that bars for "Most Recent RP" for subdimensions 'Self-Awareness' and 'Self-Efficacy' are yellow and the bars for "Most Recent RP" for subdimensions "Resilience" and "Stress Management" are green. Is there a hack to do this? I tried setting color rules on the subdimension names, but that doesn't allow me to keep the "Onboarding Baseline" bars all gray. Nested color rules didn't work either.

 

Thanks for your help!

 

 

MarkSnodgrass

I tested with what I think is similar data and was able to get it to do what I think you want it to do.

Try setting a color rule for Most Recent RP to be a certain color and then set another color rule for Self-Awareness to be yellow as well as setting a color rule for Self-Efficacy to be yellow. Then do the same for Resillience and Stress Management and set each of their rules to green. 

Basically, you will have quite a few color rules, but it seems to work.

Hope this helps.

Here are screenshots of what I did: