Hi,

You mean the part about adding new series, moving it to the secondary axis
and formatting the secondary x axis so specific dates correspond to dates
and not category tickmarks?

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"lbb" wrote in message
...
Hi Andy,

There's one thing missing in your example -- that's how you get the
proper
X values associated with the new data series. I have four of them and
they're just lining up with the major tick marks. I need them to show up
instead in locations that correspond to certain dates. Any ideas?

"Andy Pope" wrote:

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