Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
sot sot is offline
external usenet poster
 
Posts: 19
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.charting
sot sot is offline
external usenet poster
 
Posts: 19
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
Excel chart draws line outside Y axis pc Charts and Charting in Excel 2 July 24th 06 01:36 AM
how can i change position of x and y axis in chart? zare-jamal Charts and Charting in Excel 2 October 27th 05 01:35 PM
auto position of data labels in a line chart Nick Turner Charts and Charting in Excel 2 October 18th 05 11:43 PM
How do I switch the axis values in my chart Melissa Charts and Charting in Excel 3 February 9th 05 01:55 PM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"