Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
create multiple scatterplot from 3 columns
Hi,
Is it possible to create a scatterplot with multiple series (2) from a dataset with 3 columns: group X Y A 1,9 9,6 B 9,9 3,6 A 8,3 8,4 B 7,7 5,8 B 6,9 0,8 C 6,8 7,3 C 8,2 8 D 6,8 4,5 D 3,1 5,3 E 3,3 5,9 The firts column defines the group (each group has a different symbol), the second and third define the X and Y coordinates. My dataset contains about 400 lines and has 15 groups, which is too much work to copy the XY from each group to different columns. I'm working in Excel 2003. many thanks, Maarten |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
create multiple scatterplot from 3 columns
You cannot use this data to make a chart. You need to separate the X and Y
into different columns. This is easy enough to do: insert a column between the current X and Y comma separated pairs, then split each using Date menu Text To Columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maarten" wrote in message ... Hi, Is it possible to create a scatterplot with multiple series (2) from a dataset with 3 columns: group X Y A 1,9 9,6 B 9,9 3,6 A 8,3 8,4 B 7,7 5,8 B 6,9 0,8 C 6,8 7,3 C 8,2 8 D 6,8 4,5 D 3,1 5,3 E 3,3 5,9 The firts column defines the group (each group has a different symbol), the second and third define the X and Y coordinates. My dataset contains about 400 lines and has 15 groups, which is too much work to copy the XY from each group to different columns. I'm working in Excel 2003. many thanks, Maarten |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
create multiple scatterplot from 3 columns
Ha, but they are already separated into 3 columns. The problem is that the
program should recognize different series (A, B, C, D, ...) from the first column. I know how to create the scatterplots when the X and Y of each serie are in separate columns (e.g. column 1 has X from serie 1, column 2 has Y from serie 1, column 3 has X from serie 2, c4 the Y from serie 2, c5 the X from serie 3, etc...). However, it takes too much work to copy-paste each time all the X and Y from each serie into different columns. is there a way to define automatically all the series from column 1? By using a macro or so? "Jon Peltier" wrote: You cannot use this data to make a chart. You need to separate the X and Y into different columns. This is easy enough to do: insert a column between the current X and Y comma separated pairs, then split each using Date menu Text To Columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maarten" wrote in message ... Hi, Is it possible to create a scatterplot with multiple series (2) from a dataset with 3 columns: group X Y A 1,9 9,6 B 9,9 3,6 A 8,3 8,4 B 7,7 5,8 B 6,9 0,8 C 6,8 7,3 C 8,2 8 D 6,8 4,5 D 3,1 5,3 E 3,3 5,9 The firts column defines the group (each group has a different symbol), the second and third define the X and Y coordinates. My dataset contains about 400 lines and has 15 groups, which is too much work to copy the XY from each group to different columns. I'm working in Excel 2003. many thanks, Maarten |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
create multiple scatterplot from 3 columns
Oh, you're using the comma as a decimal separator, not to separate X and Y
within a cell. Duh, my bad. This example shows how to separate out the series' Y values easily, using formulas in columns off to the right of the data: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maarten" wrote in message ... Ha, but they are already separated into 3 columns. The problem is that the program should recognize different series (A, B, C, D, ...) from the first column. I know how to create the scatterplots when the X and Y of each serie are in separate columns (e.g. column 1 has X from serie 1, column 2 has Y from serie 1, column 3 has X from serie 2, c4 the Y from serie 2, c5 the X from serie 3, etc...). However, it takes too much work to copy-paste each time all the X and Y from each serie into different columns. is there a way to define automatically all the series from column 1? By using a macro or so? "Jon Peltier" wrote: You cannot use this data to make a chart. You need to separate the X and Y into different columns. This is easy enough to do: insert a column between the current X and Y comma separated pairs, then split each using Date menu Text To Columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maarten" wrote in message ... Hi, Is it possible to create a scatterplot with multiple series (2) from a dataset with 3 columns: group X Y A 1,9 9,6 B 9,9 3,6 A 8,3 8,4 B 7,7 5,8 B 6,9 0,8 C 6,8 7,3 C 8,2 8 D 6,8 4,5 D 3,1 5,3 E 3,3 5,9 The firts column defines the group (each group has a different symbol), the second and third define the X and Y coordinates. My dataset contains about 400 lines and has 15 groups, which is too much work to copy the XY from each group to different columns. I'm working in Excel 2003. many thanks, Maarten |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
create multiple scatterplot from 3 columns
Works fine, thanks!
"Jon Peltier" wrote: Oh, you're using the comma as a decimal separator, not to separate X and Y within a cell. Duh, my bad. This example shows how to separate out the series' Y values easily, using formulas in columns off to the right of the data: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maarten" wrote in message ... Ha, but they are already separated into 3 columns. The problem is that the program should recognize different series (A, B, C, D, ...) from the first column. I know how to create the scatterplots when the X and Y of each serie are in separate columns (e.g. column 1 has X from serie 1, column 2 has Y from serie 1, column 3 has X from serie 2, c4 the Y from serie 2, c5 the X from serie 3, etc...). However, it takes too much work to copy-paste each time all the X and Y from each serie into different columns. is there a way to define automatically all the series from column 1? By using a macro or so? "Jon Peltier" wrote: You cannot use this data to make a chart. You need to separate the X and Y into different columns. This is easy enough to do: insert a column between the current X and Y comma separated pairs, then split each using Date menu Text To Columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maarten" wrote in message ... Hi, Is it possible to create a scatterplot with multiple series (2) from a dataset with 3 columns: group X Y A 1,9 9,6 B 9,9 3,6 A 8,3 8,4 B 7,7 5,8 B 6,9 0,8 C 6,8 7,3 C 8,2 8 D 6,8 4,5 D 3,1 5,3 E 3,3 5,9 The firts column defines the group (each group has a different symbol), the second and third define the X and Y coordinates. My dataset contains about 400 lines and has 15 groups, which is too much work to copy the XY from each group to different columns. I'm working in Excel 2003. many thanks, Maarten |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create multiple columns within one column? | Excel Discussion (Misc queries) | |||
How can i create a scatterplot with small and medium values? | Charts and Charting in Excel | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
can i create multiple columns from the info in one cell | Excel Discussion (Misc queries) |