Turning a linechart 90 degrees

  • Thread starter Thread starter Nemo
  • Start date Start date
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!
 
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
 
You must log in or register to reply here.

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

Scatter Chart 1
Reversing Dates Sequence along X axis in a chart 3
Question about easy qualitative graph 1
How to draw a graph with the X axis as a time line of date. 4
Exel - add vertical line to two axis graph 0
Create vertical label on worksheet 3
chart dates and times (excel 2007) 3
Calculation of Area Under a Continuos curve......Scatter Curve. 0

Back
Top