Turning a linechart 90 degrees

N

Nemo

I need to turn a linechart 90 degrees so that the x-axis is vertically
and the y-axis is horizontally. I tried this with a spreadchart but
then I lose the category (x) axis and get two result (y) axis.

It sounds like an easy problem, but can anybody give me the decisive
tip as to how to solve this!
 
T

Tushar Mehta

If you mean you want to rotate the graph (i.e., not just interchange x
and y), see the link 'Invert and rotate charts' on the page
Excel Tips and Cases
http://www.tushar-mehta.com/excel/tips/

Note that the direct link to the tutorial will almost certainly change
in the future.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2007
 
Top