Hi,

The following pages have examples of how to add target lines.

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

Deanoreds wrote:
have a graph with 0 20 40 60 80 100 down side.
need to add extra line with 90 and line to be dotted rather than straight
like others as this is target.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info