CODEWITHSUNDEEP
excelstatisticsscatter-plotevaluation
Khaled
Khaled

Reputation: 563

connecting data points of different series in scatter chart (EXCEL)

Below is a scatter chart that displays two data sets using excel. the blue data set are observed(actual) location coordinates of detected small cars on a world plane. The orange data set represent the same location coordinates, however reconstructed using inverse mapping process which consists of many processes like camera calibration, finding camera pose, etc. Scatter

So my question is

is there a way i can connect every blue point with its correspondent orange one in Excel ?

Thanks in Advance

Upvotes: 1

Views: 2218

Answers (1)

learnAsWeGo
learnAsWeGo

Reputation: 2282

Apologies for misunderstanding problem.

We will will start by creating two series, one for observed and another for reconstructed.

We then create a new series for each observed and reconstructed pair. Each of these series will have a line connecting them.

We then order the series such that the first two series we created, of the observed and reconstructed data sets, are brought to the front.

enter image description here

Upvotes: 1

Related Questions