switching axis x to y and y to x

Posted by sean on January 29, 2002 5:11 AM

I have 2 columns of data. Column A is depth, Column B is corresponding temperature.

When I make a chart, the depth always seem to be on the x axis but I want it on the Y axis. How can this be done?

thanks very much.

sean

Posted by Mark W. on January 29, 2002 6:53 AM

Move temperature to column A and then create your
chart or edit your chart's SERIES function so
that it looks like...

=SERIES(,Sheet1!$B$2:$B$10,Sheet1!$A$2:$A$10,1)

...of course, use your own beginning and ending
row numbers!