Hello all, while I am fairly competent with Excel in other areas, I have never once had to make use of the chart functionality before.
I have been provided a spreadsheet with several columns of data. I have been asked to plot this data with one column being the Y axis, and the rest being on the X axis.
The Y axis are columns with various pressures.
The X axis is a column with depths, in ascending order.
The way the spreadsheet is formatted is basically
Depth PSI1 PSI2 PSI3 PSI4
10 12 14 1 92
9 6 67 2 75
8 3 48 5 88
7 9 21 6 74
6 1 10 8 74
5 0 89 9 93
4 1 43 3 54
3 7 45 2 85
2 8 67 7 31
1 4 62 4 57
(random numbers)
So I would like to plot
PSI1 - PSI4 on the Y (vertical) axis and Depth on the X (horizontal) axis, with each PSI column getting it's own line.
When trying to insert a line graph, it forces some odd row vs column plot. So I get a mismash of depths and psi's plotted against eachother. Hitting the switch row/column button simply takes that mismash of data an reverses it's axis.
I have found that if I highlight all of the data and choose a scatter plot I get a great graph with Depth on the Y axis and the PSI values on the X axis. I have been asked to swiotch these values though and plot them on reverse axis. I can't seem to find a way to do this.
Any help would be greatly appreciated.
Thank you.
Bookmarks