Change the legend description when using conditional formatting
Hello and good day,
I have a column, Violation type, that takes the values 'Availability', 'TTR', ...
I have used conditional formatting to show the data and I want to use that also in the chart.
Using the condition Violation Type equal to 'Availability', I specify the colour.
Although in the chart the correct colours are shown, in the legend part, the condition (equal) is also shown.
I would like to see only the values there and not the conditions I made, e.g. instead of 'Equal Availability' to have 'Availability'.
How can I achieve that? (we use version 7.3)