View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Vertical Lines on the Lines on 2 Axes Chart

It's probably better to start with the regular line chart type, rather than
the built-in custom lines on two axes type. Then double click one series,
and on the Axis tab, select Secondary.

To add a line in H or V orientation:

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

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

wrote in message
oups.com...
I was wondering if it is possible to place a vertical line in the
"Lines on 2 Axes" Chart.

I usually add extra data series if I want to make extra lines but for
this type of graph, it very difficult if not impossible. Adding
Horizontal lines are no problem because that's the direction my data is
going but the vertical conflicts with it. When I try and specify the
location I want the vertical line to be at, it ends up getting very
messy. Any advice?

Judokid