Can I switch axes in a Worksheet?

[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...

 

[Jay]

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. ...

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

 

[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