Remember Me?

#### Menu

#1
April 11th 06, 07:48 AM posted to microsoft.public.excel.charting
 Debby Blaine Posts: n/a
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.

#2
April 11th 06, 09:07 AM posted to microsoft.public.excel.charting
 Carim Posts: n/a
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

#3
April 11th 06, 09:08 AM posted to microsoft.public.excel.charting
 Andy Pope Posts: n/a
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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MikeR-Oz Charts and Charting in Excel 4 February 6th 06 07:01 AM Tim Gilderseeve Charts and Charting in Excel 2 June 11th 05 07:53 AM Jackie Charts and Charting in Excel 1 May 3rd 05 05:10 PM Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM Nikki Charts and Charting in Excel 3 February 4th 05 04:42 AM

All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017