Hi,

Does this help?
http://www.andypope.info/ngs/ng47.htm

If not post back and include details of the article you used from your
websearch.

Cheers
Andy

lbb wrote:
I have a line chart with date values on the x axis. I want to add vertical
marker lines on the chart to show when certain events happened (which do not
correspond to dates for which there is data in the line chart). I did a
websearch and supposedly you can do this with something called the "series
method", so I tried that. It worked all right, except where my vertical bar
showed up on the chart was nowhere near the date that I'd assigned to it;
hence, not very useful. I tried the "error bar method" and the results were
even more ghastly and useless. Is there a method for doing this that
actually works?

Thanks,

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info