GRAPH Prioritys

[Corleone]

i have a dashboard with 12 graphs on it
they are all set up the same way In terms of the line priority order being
1.Forecast
2.Actual
3.Baseline

with 3 lines on the graph showing forecast , actual and baseline



the query i have is that on the first 2 graphs the forecast line appears in front of the actual line thus obsuring it however,on all the rest of the graphs the actual line appear on top and the forecast line appears as a secondary priority which is what i want.

the other query i have is in order to get the "actual" line to appear on the top i seem to have to select is as a secondary priority, if i move it up to the 1st priorty, the ramge on the forecast line suddenly reduces

 

[Steve=True]

Have you thought about using something other than line charts? You will always have this problem with lines.

You probably need something like a bullett graph:

Explains the chart type:
http://www.perceptualedge.com/blog/?p=217

Here is how to do it in excel:
http://www.exceluser.com/explore/bullet.htm

let me know if you need help in the implementation.
bullet chart or a bar chart with lines?