Average line on chart

[APH]

Hi

I have created a chart using data from C2:AR2, which works Ok

Now what I want to do is to add a line across the width of the chart which
shows the average of C2:AR2, so that I can immediately see which elements
are above average and which are below.

is this possible please and if so how?

Thanks

Alex

 

[Debra Dalgleish]

Jon Peltier has instructions for adding a Horizontal Line to a chart:

http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#AddLine