how do I plot a constant value in a line graph?
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. |
how do I plot a constant value in a line graph?
Hi, IMHO, I would add a line filled with the constant value ... Cheers Carim -- Carim ------------------------------------------------------------------------ Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259 View this thread: http://www.excelforum.com/showthread...hreadid=531796 |
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 |
All times are GMT +1. The time now is 04:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com