ExcelBanter - Trendline

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Trendline (https://www.excelbanter.com/new-users-excel/195279-trendline.html)

Carlo

Trendline

How do I create multiply trendlines on one graph. I have 5 years data on one
graph and I want to show a linear trendline for each year on the one graph?
Thanks

Mike H

Trendline

Select and right click each of the series in turn
Select 'Add Trendline'
Select the line type
Click OK

Mike

"Carlo" wrote:

How do I create multiply trendlines on one graph. I have 5 years data on one
graph and I want to show a linear trendline for each year on the one graph?
Thanks

All times are GMT +1. The time now is 03:38 AM.