Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sirritys
 
Posts: n/a
Default How can I plot data in different columns to same curve

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

  #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


  #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 :-/.

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

Btw, I'm using excel '97

  #5   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
ups.com...

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




  #6   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:

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)

  #7   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...

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


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

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using multipe source data to plot on one chart tom zane Charts and Charting in Excel 1 March 17th 06 11:52 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
Data in narrow columns truncated when saving as DBF Ben Amada Excel Discussion (Misc queries) 2 October 11th 05 11:23 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 03:04 AM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"