How would I go about adding a horizontal line to a chart.

I am trying to make a line chart and need to place a horizontal line at 80% 
across the entire chart.  How can I do this?

QB

Insert / Illustrations group / Shapes / Line - draw across at 80% mark. 

If my comments have helped please hit Yes. 

Thanks. 

"QB" wrote:

> How would I go about adding a horizontal line to a chart.
> 
> I am trying to make a line chart and need to place a horizontal line at 80% 
> across the entire chart.  How can I do this?
> 
> QB

Hi,

Use a dummy series to draw the line.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

On 24/02/2010 01:10, QB wrote:
> How would I go about adding a horizontal line to a chart.
>
> I am trying to make a line chart and need to place a horizontal line at 80%
> across the entire chart.  How can I do this?
>
> QB

-- 

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