ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2003 Line Chart - Switch Axis Position (https://www.excelbanter.com/charts-charting-excel/159891-excel-2003-line-chart-switch-axis-position.html)

sot

Excel 2003 Line Chart - Switch Axis Position
 
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

Excel 2003 Line Chart - Switch Axis Position
 
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
_______


"sot" wrote in message
...
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?




sot

Excel 2003 Line Chart - Switch Axis Position
 
Brilliant. Many thanks!

"Jon Peltier" wrote:

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
_______


"sot" wrote in message
...
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?






All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com