Quote Originally Posted by Richard Buttrey View Post
Hi,

In that case just right click on the chart, select Source data and add the new series for average. i.e. this will be the =AVERAGE($B$1:$B$7) function copied to C1:C7.

Then right click the new series (default) column, pick Chart Type and select 'line'.

Rgds
Thats great - thanks