M
Maarten
Hi,
is there any way to define different series for a scatterplot from a single
column?
I have data organised in three columns: column 1 and 2 contain the X and Y
coordinates and column 3 contains the codes (to define the series).
X Y code
-0,25586 -1,41622 A
0,00779 -1,27963 A
0,80316 -0,56037 A
0,72824 0,40388 A
0,89184 0,53479 A
-0,44546 -0,11075 B
-0,28927 -0,16976 B
-0,02147 0,18616 B
0,01244 0,63664 B
0,01123 0,66995 B
Normally you put the series next to each other, but that is very time
consuming if you have a lot of series. It would be easier if Excel could
recognize the labels in column 3 as separate series.
Maarten
is there any way to define different series for a scatterplot from a single
column?
I have data organised in three columns: column 1 and 2 contain the X and Y
coordinates and column 3 contains the codes (to define the series).
X Y code
-0,25586 -1,41622 A
0,00779 -1,27963 A
0,80316 -0,56037 A
0,72824 0,40388 A
0,89184 0,53479 A
-0,44546 -0,11075 B
-0,28927 -0,16976 B
-0,02147 0,18616 B
0,01244 0,63664 B
0,01123 0,66995 B
Normally you put the series next to each other, but that is very time
consuming if you have a lot of series. It would be easier if Excel could
recognize the labels in column 3 as separate series.
Maarten