Graph
 

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.

Graph
 

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