Excel 2010 - Plot lines between multiple ordered pairs

[FLSteve]

I've got multiple ordered pairs and would like to plot them on a scatter plot and draw a pairing line between each ordered pair.

Series 1; Series 2
X1, Y1; A1, B1
X2, Y2; A2, B2
X3, Y3; A3, B3
X4, Y4; A4, B4


Basically all 8 points would be plotted and I'd like a line between X1, Y1 and A1, B1 and the other 3 pairs.
Any ideas? I know how to plot all the points on a scatterplot. I don't know how to draw the 'pairing lines'

 

[Andrew Poulsom]

Isn't there only one point for X1, Y1?

 

[ZofiaOS]

Try this code:

Sub createChart()
    'create a chart
    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.ChartType = xlXYScatterSmooth
    
    'we have to create a series for each pair of points
    Dim cell As Range
    'change Range("A1:A3") to your range
    For Each cell In Range("A1:A3")
        With ActiveChart.SeriesCollection.NewSeries
            .Name = cell.Row
            
            'xRange are X and A values
            xRange = "A" & cell.Row & ",C" & cell.Row
            'yRange are Y and B values
            yRange = "B" & cell.Row & ",D" & cell.Row
            
            .XValues = ActiveSheet.Range(xRange)
            .Values = ActiveSheet.Range(yRange)
        End With
    Next cell


End Sub

 

[ZofiaOS]

If you don't want to use code you can also do it manually. Create a scatter with lines chart and then for each pair of points add a seperate series (in select data menu of the chart). For X values pick X and A cells and for Y values pick Y and C cells.
For example for pair number 2, X values would be cell X2 and A2 and Y values would be Y2 and B2.