Chart Target Line

's Computer Specifications

Is there anyway to have a target line on typical column chart?

I know that I can manually draw a line but I would like for it to be
there if possible from source data.

Thanks for all help.

--
AlDeb
------------------------------------------------------------------------
AlDeb's Profile: http://www.excelforum.com/member.php...o&userid=25391
View this thread: http://www.excelforum.com/showthread...hreadid=475078

's Computer Specifications

Jon Peltier has instructions for adding a horizontal line to a chart:

http://www.peltiertech.com/Excel/Cha...s.html#AddLine

AlDeb wrote:
> Is there anyway to have a target line on typical column chart?
>
> I know that I can manually draw a line but I would like for it to be
> there if possible from source data.
>
> Thanks for all help.
>
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Goal line or target line to Excell 2007 Chart	hawaiiham2000	Microsoft Excel Charting	5	2nd Oct 2009 05:35 PM
How do I add a horizonal target/goal line to a line chart?	excelbanker	Microsoft Excel Charting	2	30th Oct 2008 07:52 PM
How do I add a target line to a chart?	=?Utf-8?B?c29jb25mdXNlZA==?=	Microsoft Excel Charting	1	15th Jun 2007 02:52 PM
target line in bar chart	chinascot69	Microsoft Excel Charting	1	28th Jul 2006 12:50 PM
Re: ADD TARGET LINE TO CHART	Debra Dalgleish	Microsoft Excel Charting	0	10th Sep 2003 01:02 AM