I have created a chart representing a geological profile/cross-section. On the vertical axis you can see the height in metres above sea level and on the horizontal axis you can see the distance in metres (about 400).
The chart is currently based on this data:
Now I want to add this data, which gives the positon of objects along the profile:
How can I add this data to the chart and use the same horizontal scale, so that the objects are plotted in the middle of the diagram?
I have tried adding the data by right-clicking the chart --> Select data --> Add new data. However, it doesn't recognize the distance values belong to the existing horizontal axis. Instead, they end up on the vertical axis:
Simply put, how do I plot the objects along the existing horizontal axis based on the values in the Distance column?
I use Excel 2016.