macgriogar1
Programmer
thread702-281146
I think I have a solution.
Assume the first series x values range from 1 to 100. these will go in column 1 of a table with the corresponding y values in column 2.
Append series2 x values to the end of the series 1 x values in the first column (e.g. rows 101 thru 200). Enter the series2 y values in the 3rd column but only in those rows corresponding to the 2nd series x values (e.g. again 101 thru 200). Do the same for series3 with the x values appended in column 1 (e.g. 201 thru 300) and the series3 y values in the same rows but in column 4. In the Row Source field for the scatter plot enter "select * from tbl_whatever". If you want the points in each series connected by lines you have to sort the x values for each series before populating the table.
I think I have a solution.
Assume the first series x values range from 1 to 100. these will go in column 1 of a table with the corresponding y values in column 2.
Append series2 x values to the end of the series 1 x values in the first column (e.g. rows 101 thru 200). Enter the series2 y values in the 3rd column but only in those rows corresponding to the 2nd series x values (e.g. again 101 thru 200). Do the same for series3 with the x values appended in column 1 (e.g. 201 thru 300) and the series3 y values in the same rows but in column 4. In the Row Source field for the scatter plot enter "select * from tbl_whatever". If you want the points in each series connected by lines you have to sort the x values for each series before populating the table.