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/charts...nes/index.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"FL" wrote in message
...
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