change bar style based on condition

[#1]

Hi all,

Maybe this is simple, but I cannot find the solution.

I have a bar chart based on 2 dimensions, so I have 3, 4 or 5 different colors; for each product a color.

I would like to change the style or color or anything....after a condition.

So if the count of a specific product is <100, the color or style of the bars must change.

I already tried background color, but if I do that and change for example in lightgray, all the colors will change to gray. The colors must be 'like' original color, so I can find them in the legenda.

What i would like to have, is for example stripes or dotts in the bars if the condition is valid. Then they will keep their original color.Or another solution is if the color can be made 50% of the original color (that would be really nice) if the condition is valid.

By the way: I prefer not to use 2 graphs for this (of course only if there's no other way)

Does this makes sence?

Thank you!

Patricia

[#2]

Can anyone tell me if the above question is impossible to solve?

[#3]

Hi Patricia,

please see the attached example.

I´m not exactly sure if this is what you are looking for.

Good luck!

Rainer

[#4]

Hi Rainer!

Thank you for thinking with me and for your respons.

Unfortunately this is not what my customer would like. This thing is: all counts<100 will be yellow now. Also in the legenda. You cannot easily see the difference in for example damen-, herren mode und sportswear.

I already tried this with gray.

Thanks again for your response.

[#5]

Hi Patricia,

please see the new example. It seems to be near at what you are looking for.

Have a nice weekend!

Rainer