View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default how do I plot a constant value in a line graph?

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