View Single Post
  #1   Report Post  
Anne-SFRunner
 
Posts: n/a
Default In excel scatter plot with 2 series, how do I connect xy coordinat

I have an xy-scatter plot with 2 series, say Series1 and Series2. The data
is arranged in 4 columns, Series1-x-values, Series1-y-values,
Series2-x-values and Series2-y-values. I would like to draw a line between
the Series 1 and Series 2 xy-coordinate for each row in my data. Does anyone
have good tips on doing this? I would appreciate any help.
Thanks,
Anne