G geooil Nov 17, 2004 #1 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
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
J Jon Peltier Nov 19, 2004 #2 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/ _______
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/ _______
