Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
smithers2002
 
Posts: n/a
Default Can you have a vertical line graph in Excel 2003

Is it possible to make a combination graph with a vertical line graph
included? It would appear you can only have line graphs which are plotted on
the y graph at the moment
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You can use an XY Scatter chart instead, perhaps using a dummy series to provide
non-numeric vertical axis labels:

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

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

smithers2002 wrote:

Is it possible to make a combination graph with a vertical line graph
included? It would appear you can only have line graphs which are plotted on
the y graph at the moment


  #3   Report Post  
smithers2002
 
Posts: n/a
Default

Hi, Thanks, I looked at your site but the graph does not work. I am using a
100% stacked bar chart/stacked bar chart and need a vertical series showing
another value- when I try to do this, it keeps returning the values on a
horizontal axis. Please help, its really annoying me!


"Jon Peltier" wrote:

You can use an XY Scatter chart instead, perhaps using a dummy series to provide
non-numeric vertical axis labels:

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

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

smithers2002 wrote:

Is it possible to make a combination graph with a vertical line graph
included? It would appear you can only have line graphs which are plotted on
the y graph at the moment



  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

The XY Scatter chart series overlaid on the Bar chart has vertical Y and horizontal
X, while the bar chart series have vertical X and horizontal Y. For the XY Scatter
series, use a Y coordinate that goes from 1 to N, 1 corresponding to the lowest
horizontal bar category, and N to the number of categories. Use an X value
corresponding to the Y values of the bars.

This is the relevant page:

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

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

smithers2002 wrote:

Hi, Thanks, I looked at your site but the graph does not work. I am using a
100% stacked bar chart/stacked bar chart and need a vertical series showing
another value- when I try to do this, it keeps returning the values on a
horizontal axis. Please help, its really annoying me!


"Jon Peltier" wrote:


You can use an XY Scatter chart instead, perhaps using a dummy series to provide
non-numeric vertical axis labels:

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

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

smithers2002 wrote:


Is it possible to make a combination graph with a vertical line graph
included? It would appear you can only have line graphs which are plotted on
the y graph at the moment




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
How do I "index" data in a line graph? ShirleyJL Charts and Charting in Excel 2 January 10th 05 11:06 PM
Excel graph y axis label cut murreleteer Charts and Charting in Excel 2 January 9th 05 03:22 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
How does Excel 2003 calculate trendlines with respect to axes? BeefmanSteve Charts and Charting in Excel 2 December 22nd 04 11:53 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


All times are GMT +1. The time now is 02:59 PM.

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

About Us

"It's about Microsoft Excel"