X,Y plotting

[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

 

[Dan E]

Use a "XY (Scatter)" instead of a "Line" chart

Dan E

 

[Mike Middleton]

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

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