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