Adding an average line
I was adding an average line like this
Series 1 Series 2 10 average(series1)=25 20 25 30 25 40 25 and plotting the average line. I then tried plotting a linear trendline, with the 'set intercept' set to the average (25). However the lines were not always perfectly horizontal (I can't understand why). Is there a way to create an average line? |
Adding an average line
basically I want to write y = averagevalue
"Gaijintendo" wrote: I was adding an average line like this Series 1 Series 2 10 average(series1)=25 20 25 30 25 40 25 and plotting the average line. I then tried plotting a linear trendline, with the 'set intercept' set to the average (25). However the lines were not always perfectly horizontal (I can't understand why). Is there a way to create an average line? |
Adding an average line
Hi,
The use of additional series is the way to do it. There are more alternatives explained here. http://www.andypope.info/charts/averageline.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gaijintendo" wrote in message ... I was adding an average line like this Series 1 Series 2 10 average(series1)=25 20 25 30 25 40 25 and plotting the average line. I then tried plotting a linear trendline, with the 'set intercept' set to the average (25). However the lines were not always perfectly horizontal (I can't understand why). Is there a way to create an average line? |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com