You need each year plotted as a separate data series, then follow Mike's
advise
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Carlo" wrote in message
...
How can I create multiple trendlines on one graph i.e I have a graph with
5
years data and I want to show a linear trendline for each year on the same
line?