Rotating axes in a worksheet
 

Is it possible to reverse the X- and Y- axes in an Excel worksheet? If so,
how?

For example, if I have:

A B C D E
1 2 3 4 5

I'd like to change it so it becomes

A 1
B 2
C 3
D 4
E 5

Thanks in advance,
Oliver.

Rotating axes in a worksheet
 

Sure, copy all of the date then right-click, paste special, click the
transpose box.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Oliver Bouckley" wrote:

Is it possible to reverse the X- and Y- axes in an Excel worksheet? If so,
how?

For example, if I have:

A B C D E
1 2 3 4 5

I'd like to change it so it becomes

A 1
B 2
C 3
D 4
E 5

Thanks in advance,
Oliver.

Rotating axes in a worksheet
 

Copy/ Edit/ Paste Special/ Transpose
--
David Biddulph

"Oliver Bouckley" wrote in
message ...
Is it possible to reverse the X- and Y- axes in an Excel worksheet? If
so,
how?

For example, if I have:

A B C D E
1 2 3 4 5

I'd like to change it so it becomes

A 1
B 2
C 3
D 4
E 5

Thanks in advance,
Oliver.

Rotating axes in a worksheet
 

Ta muchly.

Typical - I've wanted to know how to do this for YEARS and no colleagues
have been able to help. As soon as I posted the question I stumbled across
the answer, so the responses must have filtered through to me by osmosis!



"David Biddulph" wrote:

Copy/ Edit/ Paste Special/ Transpose
--
David Biddulph

"Oliver Bouckley" wrote in
message ...
Is it possible to reverse the X- and Y- axes in an Excel worksheet? If
so,
how?

For example, if I have:

A B C D E
1 2 3 4 5

I'd like to change it so it becomes

A 1
B 2
C 3
D 4
E 5

Thanks in advance,
Oliver.