Trendline of multiple series

[geooil]

Am I able to calculate the trend over multiple sheets to get on
inclusive trend using the trend function, if so how do I do i

 

[Jon Peltier]

How many data points? You cannot plot data that stretches over multiple sheets
without somehow consolidating it:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

I'm not sure LINEST works with ranges that cross sheets either.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______