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


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



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,co mpanyname!$F$39:$F$42,companyname!$G$39:$G$42)

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