Can I switch axes in a Worksheet?

  • Thread starter Thread starter Amy
  • Start date Start date
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...
 
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
 
It sounds like you're looking for the "transpose" function.

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

-Mark
 
Back
Top