Can I switch axes in a Worksheet?

A

Amy Sheller

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??
 
A

Amy

Excellent! thanks!!
-----Original Message-----
Amy

Can you Copy>Paste Special>Transpose to a new worksheet?

If you have more than 256 rows you cannot Transpose the rows to columns.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I reverse the axes of a populated worksheet (X to Y, Y to X)? 4
Changing the setting of X,Y axes 0
2 Horizinotal axes in Excel 2007 4
Can I switch axes in a Worksheet? 2
WORD VBA Search and switch to advanced ... 1
xy-chart axes lower and upper limits dynamically set by data seriesvalues 0
Unintended line connecting two data points 0
How to dynamically set the lower and upper limits of the axes on a MSAccess xy-chart. 0

Top