XY scatter chart

Hi,

I'm using an XY scatter chart to plot some numbers on the Y scale and using
the X scale to plot time. It works great for my application. Now I would
like to drawing a few lines to show my control limits. However these control
limit lines are horizontal then taper down diagonally to the zero Y axis
point on my time scale after about 6 verticle grid lines to the appropriate
time. This is ok if my time scale doesn't move. However, my time scale will
slightly self adjust to reflect short or long times. How can I get my
control lines to move along with these automatic time scale adjustments that
Excel creates? Or, am I asking too much of the program? Or, should I be
using some other program to do this?
--
FL

Hi,

Here are some sites on the topic of adding datum lines to charts.

http://peltiertech.com/Excel/Charts/AddLine.html
http://www.andypope.info/charts/averageline.htm
http://tushar-mehta.com/excel/chart...ines/index.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"FL" <FL@discussions.microsoft.com> wrote in message
news:045B14A7-DC4C-40AE-B187-8A2D9B2C3C50@microsoft.com...
> Hi,
>
> I'm using an XY scatter chart to plot some numbers on the Y scale and
> using
> the X scale to plot time. It works great for my application. Now I
> would
> like to drawing a few lines to show my control limits. However these
> control
> limit lines are horizontal then taper down diagonally to the zero Y axis
> point on my time scale after about 6 verticle grid lines to the
> appropriate
> time. This is ok if my time scale doesn't move. However, my time scale
> will
> slightly self adjust to reflect short or long times. How can I get my
> control lines to move along with these automatic time scale adjustments
> that
> Excel creates? Or, am I asking too much of the program? Or, should I be
> using some other program to do this?
> --
> FL