How to merge four line graphs with each two drawn in different scales

I tried to to merge two different line graphs drawn with different scales (X-axis scale) to see the point of contact to each other but I couldn't make it. Can you guys help me to figure out this problem? I have attached excel sheet with two sheets in the same Excel file and also generated the line graph in each sheet. I am getting trouble that how I can merge these two graphs in the same graph. Please guys help me to fix this problem. Thanks

Hi,

You had multiple problems here, including:
(1) Using the wrong chart type. You want a scatter plot, the first option will do
(2) Use the x values provided on the left in this new type of chart
(3) Simply copy and paste the values from sheet 2 into the chart
(4) right click the two additional values and set them on a secondary access so that they display better.

I've attached the file with the appropriate chart made.

It sounds like this might be helpful.

http://peltiertech.com/Excel/Charts/StackedCharts.html

Dear All, Thanks for your great help. I really appreciate it. So, we can't merge two line graphs? It seemed good merging line graph with box plot but still for better precision, can I merge two line graphs of different scale values? Again thanks to etheriault, bartelba and FlameRetired.