Charting two line graphs with different time axes on the same graph

Hi all,

I am looking to plot 2 line graphs on the same time axes
However both line graphs are on different time scales

The first data entry is as such

Time [ms] Value
0 0
37 3.922717
74 8.932349
111 12.663166
148 13.619799
185 13.995856
222 16.022245
259 18.269735
296 20.096157
333 20.182049
370 18.10021
407 15.283295
444 12.283627
481 9.574662
518 7.610082
555 6.153582
592 4.747375
629 2.410727

The second is
Time [ms] Value
0 0
27.5 -0.639343
55 -0.5329
82.5 0.34737
110 0.951797
137.5 1.74881
165 3.26972
192.5 6.427589
220 9.553027
247.5 11.930308
275 13.319993
302.5 14.178011
330 14.39724
357.5 13.97062
385 13.023582
412.5 11.489367
440 9.527091
467.5 6.642268

As can be seen, the first line graph goes to 629ms, whilst the second goes to 467.5ms, as such trying to combine both graphs with the current data points would result in inaccurate combined line graphs

How would I combine both line graphs on a similar time scale proportionately?

Thank you

Dear Andy Pope,

Wow that was excellent

Could I ask, how did you manage to join the dots between the scatter plots?

Thank you,

Dear Andy,

That's brilliant!

Thank you, could I just ask, would you happen to know how to shade the area between the two lines on excel?

If so that would be wonderful

Thank you