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

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 =)

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

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=547782