Adding an average line to a Scatter graph

[Macrobiotic Brown]

Hi there,

I've created a scatter graph using values between 1-100 on the X axis, and values between 500-1000 on the Y axis.

I'd like to add a solid horizontal line to the graph indicating the average of the data values on the Y axis.

Is there an easy-ish way to add this line, or am I best to format the axis to add a thick gridline where I need it?

Thanks in advance!

 

[Andrew Poulsom]

One way:

http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

 

[Macrobiotic Brown]

Thanks mate, exactly what I needed.

Cheers.