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
Bookmarks