Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, hopefully a very simple question based on the attached example.
I have a line graph where the values for two of the lines are the same (ACTUALS & FCST2), on the graph one of the colours takes precedence (FCST2), however I want ACTUALS to show first.
Thanks
Nandy
In the sort tab click Version dimension then write:
If(VERSION='ACTUALS', 2,1)
let me know
In the sort tab click Version dimension then write:
If(VERSION='ACTUALS', 2,1)
let me know
Adjust the sort order on the chart for VERSION so that ACTUAL comes after FCST2 (Text, Z->A). The last drawn ine will overwrite the earlier lines.
You can reverse the legend order if you want that in ascending. Check Reverse Order in Properties | Presentation | (Legend) Settings
Thanks, both of those suggestions do the trick!