Excel 2003 Line Chart - Switch Axis Position

[Guest]

Hi. I have a line chart no problem. Values as usual up the vertical axis
and labels along the bottom horizontal axis. I would really like to switch
these around and have my labels going up the vertical. Is this possible?

 

[Jon Peltier]

You can't switch a line chart's orientation. However, you can fake it. Check
out the Dot Plot (tutorial and utility):

http://peltiertech.com/Excel/Charts/DotPlot.html

- Jon

 

[Guest]

Brilliant. Many thanks!

You can't switch a line chart's orientation. However, you can fake it. Check
out the Dot Plot (tutorial and utility):

http://peltiertech.com/Excel/Charts/DotPlot.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______