Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
Average line on EXCEL graph (like trend line)
Posted by Erica on August 17, 2000 5:14 AM
I would like to add an average line to a simple excel graph, but do not want to create a data series for it. Excel can do fancy trend lines - how can one add a simple average line? It must be possible!
Re: Average line on EXCEL graph (like trend line)
Posted by Tim Francis-Wright on August 17, 0100 9:42 AM
The only way I know to use the trend line
feature is add a data series made up entirely of
the average of the real data series. Hide
the data points on the chart, and give the series
a name of " ". Then, use the trend line
feature to draw a linear trend line on this
phony series. You can give the trend line
a custom name of Average if you like.
HTH
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.