Turning a linechart 90 degrees

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nemo - 24 Oct 2006 14:30 GMT

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!

Reply to this Message

Andy Pope - 24 Oct 2006 14:48 GMT

Hi,

Jon Peltier has a page on this.
http://peltiertech.com/Excel/Charts/axes.html#SwitchXY

Cheers
Andy

> 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!

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Tushar Mehta - 25 Oct 2006 03:34 GMT

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.

Signature

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

Reply to this Message

Rate this thread: