MS Excel Trend Function

[joepal]

I am trying to use the Trend function from the MS Excel 9.0 object library in a VBA module for use with MS Access. The function works fine when I use one-dimensional arrays for inputting the dependent and independent variables (simple regression), but I can't get it to work with a multi-dimensional array representing several independent variables. This function works with a multi-column range in a spreadsheet representing more than one independent variable, but I can' t seem to get it to work with a multi-dimensional array. Does anyone have any ideas on how I could use this function with more than one independent variable?

 

[ide]

Joepal,
You yuse 3D chart, I suppose..

from Excel help:
Chart types that support trendlines You can add trendlines to data series in unstacked 2-D area, bar, column, line, stock, xy (scatter), and bubble charts. You cannot add trendlines to data series in 3-D, stacked, radar, pie, surface, or doughnut charts. If you change a chart or data series so that it can no longer support the associated trendline — for example, by changing the chart type to a 3-D chart or by changing the view of a PivotChart report or associated PivotTable report — you lose the trendlines.

ide