Line Graphs where two values are the same

[Anonymous]

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

[alexandros17 · Accepted solution]

In the sort tab click Version dimension then write:

If(VERSION='ACTUALS', 2,1)

let me know

[jonathandienst]

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

[Anonymous]

Thanks, both of those suggestions do the trick!