Hello Excel Gurus.
I want to plot Depth VS Pressure. I dont know how to do it .
the Sample result of graph and data attached.
Hello Excel Gurus.
I want to plot Depth VS Pressure. I dont know how to do it .
the Sample result of graph and data attached.
Highlight your data
Create a Scatter Chart with lines
Right click on the vertical axis, and in Formatting select Reverse Values
You also want to reverse x and y:
=SERIES(,Sheet1!$B$2:$B$33,Sheet1!$A$2:$A$33,1)
Entia non sunt multiplicanda sine necessitate
6StringJazzer/shg
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks