I have a chart on which I'm using two colours for one series: red for values below a certain value and green for above.
Is there a way I could display two items in the legend for this series? So far I've tried using Iif
in the legend's expression, but it returns only one value.
I suggest you add 2 calculated fields in your dataset one for below and one above. Here you can use 2 IIf
statements to separate the values in your chart.
Alternatively you should be able to add the field in question to the chart twice and add an expression as above to each one for above and below.
In either of these cases there will be 2 entries in the legend.
I hope I'm on the right track for you however I can't test this at the moment.