Stacked bar chart showing each of 3 options from one column in different colors

[michael95677]

I have a stacked bar chart that shows if a med was reviewed with 3 possible answers, No, No Soap and Yes. One stacked bar chart shows the weekly sum of these by date. What I also need is a breakdown of each provider per date or at least the ability to show a different color based on the answer. 

The two screenshots show what I have so far and paint a better picture. In the top screenshot if I click on a date on the green color it does show me in the chart on the right how that breaks down by provider (pretend there are names there). What I was hoping for was to be able to just have a chart on the right that was a break down of the detail that shows a stacked chart per provider and the options of Yes, No and No SOAP or at least show the same colors as the chart on the left when it's clicked on so it is easy to read. Any help is greatly appreciated. 

[ChristianDGreat · Accepted solution]

Maybe I'm missing something on this. Have you tried to put the legend (Yes, No Soap and No) to the chart on the right?

[michael95677]

Good gosh. Wow, I think I need to get some more sleep. Spot on. Thank you for pointing this out.