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