Can I switch axes in a Worksheet?

A

Amy

Can I switch axes in a Worksheet? It was easier to enter
data in the current setup but now it may be easier to
analyze the data if I can switch the axes. Can it be
done?? Again, I would just like to switch the x and y
axes in the worksheet...
 
J

Jay

Amy said:
Can I switch axes in a Worksheet? It was easier to enter
data in the current setup but now it may be easier to
analyze the data if I can switch the axes. ...
Click to expand...

Select the data and use
Edit >> Copy

Then go to another worksheet and select a cell (like A:1).

Then use
Edit >> Paste special >> Transpose
 
M

Mark Buckelew

It sounds like you're looking for the "transpose" function.

The transpose function will make your rows into columns
and vice-versa.

-Mark
 
Top