Add horizontal line to chart

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

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"John" wrote in message
...
I am trying to create a single bar with a gradient from Red (bottom) to
Green
(top). I then what to create a single horizontal line going accross the
bar
at a particular point.

Any ideas? Thanks in advance.