Superimposing Graphs with Different X/Y Values

I have multiple sets of data that compare the capacity of vehicle's battery (Y) to the distance traveled (X). The data needs to be overlaid on one plot in order to show the different distances achieved by the vehicle, but I have no clue how to plot it all on the same graph as I have so many different unaligned/normalized values. For example:

 Distance (mi) [1]   Charge (%) [1]      Distance (mi) [2]   Charge (%) [2]   
 0                   99                  0                   99
 0                   99                  1                   97
 0                   99                  2                   96            + ~18 more
 1                   97                  3                   94
 2                   96                  4                   93
 4                   93                  5                   92

but with ~18 more data sets that also need to be plotted. So far I have tried to graph multiple data sets in Excel by graphing the first and then trying to paste in the second. The problem is that Excel seems to plot the charge data (Y) correctly but uses the distance (X) set from the original graph instead of using the correct values and plotting it on the same scale. Ultimately I do not care what program/method is used to accomplish this whether it be Excel or something completely different. I only want to preserve all of the data values from the different plots while overlaying them on a graph with a consistent (X/Y) scale.

Edit: Here is an example with some actual data values. The blue line is the original part of the graph and the grey line is the one that has been copied in. The only problem is that the charge % (Y) goes up and shows the distance increasing at the same time while in the actual data the charge never increases while the vehicle is moving. This is a result of the second graph being overlaid using the same distance (X) scale as the first instead of using its own values, which is exactly the problem I'm having.

Image

- - , .
.

Recent Questions...