I'm trying to make a conditional formating in a simple bar chart,
In the example attached I have the % of revenue for each region in a br chart. I have applied a conditional formating saying that if the value is higher than 25% then the color of the bar will be green, else the color will be white to hide the values under 25% for example.
The problem is that in the legend appear that the % series is white and I want the legend to show red instead.
Can anybody help me?
Thanks
Edit: Sorry I forgot to remove the section access... Now you can access
