"Sirritys" wrote in message
oups.com...

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?
--
David Biddulph

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,co mpanyname!$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?
--
David Biddulph