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

 

[David Biddulph]

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)

 

[Sirritys]

David Biddulph kirjoitti:

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

Still doesn't work. Gives me an error. and comma is selected, so I
think it doesn't like the comma.

This is how it looks right now:
=(companyname!$B$39:$B$42,companyname!$C$39:$C$42,companyname!$D$39:$D$42,companyname!$E$39:$E$42,companyname!$F$39:$F$42,companyname!$G$39:$G$42)

If I use ";" instead of comma it plots me 5 different curves :-/.

 

[Sirritys]

Btw, I'm using excel '97

 

[David Biddulph]

David Biddulph kirjoitti:

Still doesn't work. Gives me an error. and comma is selected, so I
think it doesn't like the comma.

This is how it looks right now:
=(companyname!$B$39:$B$42,companyname!$C$39:$C$42,companyname!$D$39:$D$42,companyname!$E$39:$E$42,companyname!$F$39:$F$42,companyname!$G$39:$G$42)

If I use ";" instead of comma it plots me 5 different curves :-/.

Works for me. I guess that the comma/semi-colon difference is down to
regional settings, but with exactly your expression in the values field of
Source Data for a line chart I get one line, not 5.

What type of chart are you using?
What do you have in any of the other fields in Source Data?

 

[Sirritys]

David Biddulph kirjoitti:

Works for me. I guess that the comma/semi-colon difference is down to
regional settings, but with exactly your expression in the values field of
Source Data for a line chart I get one line, not 5.

What type of chart are you using?
What do you have in any of the other fields in Source Data?

Just 5 curves, I'm using standard line chart. Data fields are these:
2002 2003 2004 2005 2006 2007
Q1 100,00 104,00 108,00 112,00 116,00 120,00
Q2 101,00 103,00 105,00 107,00 109,00 111,00
Q3 102,00 102,00 102,00 102,00 102,00 102,00
Q4 103,00 99,00 103,00 108,00 103,00

It just treats all colums like different data series' and plots
everyone differently.


I'm starting to feel this could be due my version of excel (still 97)

 

[David Biddulph]

David Biddulph kirjoitti:

Just 5 curves, I'm using standard line chart. Data fields are these:
2002 2003 2004 2005 2006 2007
Q1 100,00 104,00 108,00 112,00 116,00 120,00
Q2 101,00 103,00 105,00 107,00 109,00 111,00
Q3 102,00 102,00 102,00 102,00 102,00 102,00
Q4 103,00 99,00 103,00 108,00 103,00

It just treats all colums like different data series' and plots
everyone differently.

I'm starting to feel this could be due my version of excel (still 97)

I doubt that it's the version of Excel.
Check again what you've got in the various fields in Source Data.
[Make sure that you're looking on the Series tab, not the Data Range tab.]

Are you sure that in the *values* field for one series you've got the form
that you quoted earlier:
=(companyname!$B$39:$B$42,companyname!$C$39:$C$42,companyname!$D$39:$D$42,companyname!$E$39:$E$42,companyname!$F$39:$F$42,companyname!$G$39:$G$42)
? [or equivalent with semi-colons if thaat's what your regional settings
wants as a list separator.]

What, if anything, do you have in the other fields for that series?

Do you have any other series shown on the Series tab in in Source Data?

 

[Sirritys]

Ah yeah, I was looking data range tab.

Thanks for noting that also =)

Now I get them all on the same line, but for some reason the topics
don't work that well. I'll get 2002, 2003, 2004.. etc. to first 6
values in x-axis. Not every 4th like it's supposed to go =)


Well I'll try to figure that one out.

Thanks for the help all.