Re: Vertical Lines on the Lines on 2 Axes Chart

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I've tried starting with the line graph and adding a bar graph series
onto it and I'm getting decent results. So right now, I've got both
axis' used up. Secondary axis for the bar graph and primary axis for a
line graph. Now on top of this, I need to add a vertical line in a
graph. I tried adding another data series and changing the chart type
of that series. However, the XY Scatter and the basic line graphs
don't seem to work.


Jon Peltier wrote:
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/
_______

<Justin_Yuen@xxxxxxxxxxx> wrote in message
news:1141249603.715858.159820@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Vertical Lines on the Lines on 2 Axes Chart
    ... The XY series can go onto the same axes as the Line chart. ... Jon Peltier, Microsoft Excel MVP ... axis' used up. ... line graph. ...
    (microsoft.public.excel.charting)
  • Re: Expression for Blank Spaces
    ... Jon Peltier, Microsoft Excel MVP ... the graph and the x axis accomodates that. ... Col "C" formula out, line graph for C stops as desired, however, if I ...
    (microsoft.public.excel.charting)
  • Re: why my 2nd series scale change?
    ... Jon Peltier, Microsoft Excel MVP ... I want one scale at y left axis only but when I added another series ... I think I can delete the y right scale so the graph will be auto and no ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • Re: why my 2nd series scale change?
    ... Jon Peltier, Microsoft Excel MVP ... I want one scale at y left axis only but when I added another series ... I think I can delete the y right scale so the graph will be auto and no ...
    (microsoft.public.excel.charting)