| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I plot data in different columns to same curve
Btw, I'm using excel '97
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using multipe source data to plot on one chart | Charts and Charting in Excel | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
