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

S

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

robert111

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top