View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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.