Hi Brian, Click on a data point in your graph, then look at the equation entry box; it will show something along the lines of:
=SERIES(,table!$A$2:$A$25,table!$B$2:$B$25,2) You need to manually reverse the column letters in that expression to: =SERIES(,table!$B$2:$B$25,table!$A$2:$A$25,2) If you have more than one series in your graph you will need to do that separately for each series. I know, it's a horrible kludgy solution but it works. Good luck! On Wed, Sep 15, 2010 at 2:01 PM, PATRICK, L <[email protected]> wrote: > 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 > -- Eric Schauber Wildlife Ecologist -- Coop. Wildlife Research Lab Associate Professor of Zoology Center for Ecology Southern Illinois University Carbondale (618) 453-6940 (618) 453-6944 (fax)
