Assign a trendline or threshold

How do I assign and display a threshold or trendline on a chart? For
example, I would like to show an established and pre-determined threshold
line to show across my bar chart to show if the data lies above or below that
mark. So, it would be a straight line across rather than declining or
inclining like a trendline does.

I have never worked with one and I understand how the trendline can work,
but do not know how to display something like this. Is this possible?

Hi,

Have a look at these examples for adding, threshold, lines to charts.

http://peltiertech.com/Excel/Charts/RunChtLines.html
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Vicki wrote:
> How do I assign and display a threshold or trendline on a chart? For
> example, I would like to show an established and pre-determined threshold
> line to show across my bar chart to show if the data lies above or below that
> mark. So, it would be a straight line across rather than declining or
> inclining like a trendline does.
>
> I have never worked with one and I understand how the trendline can work,
> but do not know how to display something like this. Is this possible?
>
>

--

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