2012-11-09, 12:35 AM
Thanks for the detailed help [MENTION=128]Stereo[/MENTION], and everyone else for the replies!
It turns out what Stereo showed was exactly what I need to do - the reason I was so confused was that it's exactly what I WAS doing, but I was putting the data in a line graph, not a scatter plot, so it was also including the column of pH values I wanted for the x-axis. When I asked a TA about this he said all I needed to do was either plot it on a scatter plot (which he demonstrated worked immediately), or simply delete the pH line from my graph.
God I hate Excel. But I'm glad I knew what I was doing, up until the very last step xD.
It turns out what Stereo showed was exactly what I need to do - the reason I was so confused was that it's exactly what I WAS doing, but I was putting the data in a line graph, not a scatter plot, so it was also including the column of pH values I wanted for the x-axis. When I asked a TA about this he said all I needed to do was either plot it on a scatter plot (which he demonstrated worked immediately), or simply delete the pH line from my graph.
God I hate Excel. But I'm glad I knew what I was doing, up until the very last step xD.