how do I plot a constant value in a line graph?

[Debby Blaine]

I would like to plot an upper and lower limit in my line graph of
experimental data - is there any easy way to do this? I know I have seen
people do it before with something like ={100,100} or something - but I can't
get it to fill every space across my data range. I am using Excel 2002.

[Carim]

Hi,
IMHO, I would add a line filled with the constant value ...

Cheers
Carim

[Andy Pope]

Hi,

Here is a collection of examples of adding datum lines to charts

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

Debby Blaine wrote:
> I would like to plot an upper and lower limit in my line graph of
> experimental data - is there any easy way to do this? I know I have seen
> people do it before with something like ={100,100} or something - but I can't
> get it to fill every space across my data range. I am using Excel 2002.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info