View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default How can I plot data in different columns to same curve

"Sirritys" wrote in message
oups.com...
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 =)


Source Data values
=(Sheet1!$B$2:$B$5,Sheet1!$C$2:$C$5,Sheet1!$D$2:$D $5)
--
David Biddulph