How to plot a comparison of only 3 points against 9 in graph

[karryan]

Hi there,

I'm stuck at a point in a graph that I am creating. Attached is as far as I have gone and now i'm having a gap on how to take the 2006, 2007 which is already in graph and add in how these years compare to guidelines visually in the same graph?

for instance ratings 1-9 are grouped in guidelines 1-4, 5-7 etc. How do i add in the 3 guides against each point? I have thought about adding a secondary axis but not how best to demonstrate the range of 1-4 to appear behind or above those points?

Any help (technical and creative) is greatly as appreciated, as always

[Kaper]

More as a starting point, than a presentation ready solution, you could consider attached.
For the groups (they are different width 4-1 <> 7-5 . it makes life harder) i used the table with grupped data separeted by empty rows to do scatter plot on secondary axis

X llimit ulimit real06 real07

0.5 5% 10% 8.0% 11.6%
4.5 5% 10% 8.0% 11.6%

4.5 65% 75% 80.7% 62.1%
7.5 65% 75% 80.7% 62.1%

7.5 15% 20% 11.2% 26.3%
10.5 15% 20% 11.2% 26.3%

so for each group there are 4 lines - lower limit, upper one, 2006 and 2007

Note that on X axis I do not use 1-4 but 0.5-4.5 etc. to achieve span of the lines through whole width of the group.

see attached