I figured it out! Thanks to all of those who responded!! I needed to do this as a scatter plot, then edit the series. It took me a while to figure it out, but I did figure it out!
Thanks again for all of your help! Best regards, Brian ------------------------------------------------------------------------------------ L. Brian Patrick, Ph.D. Assistant Professor of Biology and Chair Department of Biological Sciences Dakota Wesleyan University 1200 W. University Ave. Mitchell, SD 57301 ________________________________________ From: Ecological Society of America: grants, jobs, news [[email protected]] On Behalf Of PATRICK, L [[email protected]] Sent: Wednesday, September 15, 2010 3:01 PM To: [email protected] Subject: [ECOLOG-L] help with graphing Hello, I am trying to make a very simple graph in Microsoft Excel 2007 and I simply cannot figure out how to transpose the axes. I want to make a graph of the temperature profile of a lake. We sampled the temperature every meter in 3 different areas of the lake and we always sampled to the maximum depth possible at that location: 1 meter, 3 meters, and 7 meters. Thus, I have 4 columns in Excel: The first column is "Depth" and is numbered 1 to 7 The second column, "1 meter," is the lone temperature reading at 1 meter. The third column, "3 meters," has the three temperature readings for the first three meters The fourth column, "7 meters," has the seven temperature readings for all seven readings at the 7 m deep portion of the lake. Here's what I want to do: I want Depth to be the vertical (y) axis, and temperature to be the horizontal (x) axis. The default makes depth the horizontal axis and no amount of trickery (i.e., rearranging columns, trying different column formats, transposing the matrix etc...) seems to be able to switch this! I have tried the help menu but I cannot find how to transpose the x and y axis. I did figure out how to get the labeled x axis along the top of the graph, but not at all how to get depth as the y axis and have the line graph look correct! Any help/instructions would be greatly appreciated!!! Thank you! Brian ------------------------------------------------------------------------------------ L. Brian Patrick, Ph.D. Assistant Professor of Biology and Chair Department of Biological Sciences Dakota Wesleyan University 1200 W. University Ave. Mitchell, SD 57301
