100% Stacked Column Chart Greyed out option

[Anonymous]

Hi,

Hope this makes sense, i've seen an option or setting in the past but cannot find it!

I have 2 100% Stacked Column Charts, when you click on one the other greys out data that doesn't apply. I want to stop that and have the Chart show only applicable data, so no grey areas.

How do you turn that on/off?

Many thanks!

Andrew

[MFelix · Accepted solution]

Hi @Anonymous ,

This as to do with visuals interaction you need to select on visual then format and edit interactions then you can select on the top of each visual how they interact with each other.

Check the documentation here.

Regards.

MFelix

[Anonymous]

Thankyou soooo much! Was driving me nuts!