Changing Legend in Stacked Bar Chart

[#1]

Hello,

I have a situation with Stacked Bar Chart.

I'm trying to highlight a bar when I select it, and to colour the other charts in grey.

This is currently working, but my problem is that if I select a bar, my legend is changing (becomes grey colored), and this phenomenon is what I want to avoid.

You can find an example in the attached document.

Does someone know how fix this problem?

Thank you for your future answers

Regards

[Gysbert_Wassenaar · Accepted solution]

You can try using a straight table as legend. See attached example.

[#3]

Thank you very much for you answer and time Gysbert,

I tried your solution and it works!

Have a nice day!