
Originally Posted by
Richard Buttrey
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
Bookmarks