X,Y plotting

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

does anyone know how I can merge two arrays to form (x,y)
co-ordinates ploting a single line rather than ploting the
two arrays as series against each other as the chart
wizard wants me to do?

Thanks,

Bob
 
Bob -
does anyone know how I can merge two arrays to form (x,y) co-ordinates
Click to expand...
ploting a single line rather than ploting the two arrays as series against
each other as the chart wizard wants me to do? <

Arrange each group of data with X in left column and Y in adjacent right
column. Use one group of XY values to create an XY (Scatter) chart. Select
the other group of XY values, and choose Edit | Copy. Select the chart (by
clicking just inside its outer border). From Excel's main menu, choose Edit
| Paste Special, and select the appropriate options (new points instead of
new series, X values in first column).

- Mike Middleton, www.usfca.edu/~middleton
 
Back
Top