Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "index" data in a line graph? | Charts and Charting in Excel | |||
Excel graph y axis label cut | Charts and Charting in Excel | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
How does Excel 2003 calculate trendlines with respect to axes? | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |