How can I plot data in different columns to same curve?

[Sirritys]

I have table similar to this:

2004 2005 2006
Q1 1 5 9
Q2 2 6 10
Q3 3 7 11
Q4 4 8 12


So I basicly want 1 curve that would plot values from 1 to 12.


I just can't seem to find a way to do this.


Help appreciated =)

[robert111]

use a dummy range to pull out the data in the order you want it and plot your chart using the dummy range.