chart question

I have a reference line that I want to appear on my chart. It's a straight
line (nothing complicated). I've drawn it, and it kind-a works, but
everytime I change any data or resize the chart, etc. ... the line moves
(then of course I need to look up where it was suppose to be, if I don't
have a handy previous printout). Having to move a graphic line "accurately"
in Excel is no treat!! Is there any way to lock that line with the chart?

Alternatively, is there a way to input such a line another way, so that it
remains static on the chart. I did enter a straight line of data points for
this, but because of the gap that exists in the space before and after other
real data lines, the line doesn't display across the full width of the
chart. If this is clear as mud, let me know and I'll try to explain it
differently.

Thanks.

Best to draw a line as another data series; see
http://peltiertech.com/Excel/Charts/

But if you want to use a graphic line you need to group line & chart. If you
has clicked on chart before drawing this would have happened.
To fix it: get line in correct place; click chart; hold CTRL and click Line;
now right click and select Group
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cowtoon" <noemailaddress@nowhere.com> wrote in message
news:e5HuJQPMGHA.1124@TK2MSFTNGP15.phx.gbl...
>I have a reference line that I want to appear on my chart. It's a straight
> line (nothing complicated). I've drawn it, and it kind-a works, but
> everytime I change any data or resize the chart, etc. ... the line moves
> (then of course I need to look up where it was suppose to be, if I don't
> have a handy previous printout). Having to move a graphic line
> "accurately"
> in Excel is no treat!! Is there any way to lock that line with the
> chart?
>
> Alternatively, is there a way to input such a line another way, so that it
> remains static on the chart. I did enter a straight line of data points
> for
> this, but because of the gap that exists in the space before and after
> other
> real data lines, the line doesn't display across the full width of the
> chart. If this is clear as mud, let me know and I'll try to explain it
> differently.
>
> Thanks.
>
>
>