Or use XY series, where the X is the number of categories along the X axis
(first category, use X=1; between second and third categories, use X=2.5;
etc.).

A series will stay in place relative to the axis if anything changes, while
a drawn line will stay in place relative to the chart's outer dimensions,
and drive you nuts.

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


"Denis" wrote in message
ups.com...
On Jul 11, 8:34 am, "Jon Peltier"
wrote:
If the chart has a time scale axis (go to Chart menu Chart Options
Axes
tab), you can add a series as you attempted, convert the new series to XY
(select just the series, Chart menu Chart Type), then move the new
series
to the primary axis (double click Axis tab). Repeat as needed.

Unfortunately, my chart doesn't have a time scale axis. The x-axis is
merely a set of labels that happen to be dates.

However, I found a post of yours that shows how to draw a polygon on a
chart using VBA. A quick look at the VBA looks like it gives me
enough info to figure out how to simply draw a vertical line on the
chart from top to bottom. That looks like that may be the way to go.

Denis