Best way to create a vertical line that moves when axis changes

Guido -

Try the suggestions he

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

Put some kind of formula in the cell(s) that link the point(s) values to
the axis endpoints.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Father Guido wrote:

Hi,

I have many charts that I draw vertical lines on to represent goals.
The horizontal axis is dates. I quite often need to extend the date
axis, which means I need to redraw/move the existing lines. I'm just
wondering if anyone has any magic method to create a vertical line on
a particular date, so it moves as the axis is extended.

I've tried using a series that goes from 0 to 10,000,000 on the date I
want the vertical line, then continuing that series at 10,000,000 so
it never shows up again, but there must be a better way.

I'm using XL2002.

Thanks!

Smoke and mirrors, that's all.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Father Guido wrote:
Thanks Jon, guess there's no magic, just tricks.

On Mon, 02 Feb 2004 08:17:20 -0500, Jon Peltier
wrote:


Guido -

Try the suggestions he

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