Chart Target Line

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.

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