Hiding a value on a bar chart

[#1]

See chart below:

I need to hide the "Maybe"s and Still have Yes/No populate with 45%.

I have also attached my sample QV document.

I imagine I can do this in the Expression tab? But Im not sure what syntax to use.

Thank you in advance for any input!

[paulyeo11]

Interesting post . May I know why you want to hide may be ?

[#3]

Hi,

Please see attached.

Regards,

Janzen

[#4]

The customer wants it this way. They didnt want their "maybe"s to be discounted in the numbers. The real values arent yes, no, maybe. There are many many more. NDA required that I change the data.

[#5]

Janzen, so close... but I cant see every possibility.

This file is closer to what I am really trying to do.