Thread: Series collection object

Is there anyway to take the series collection object out of a chart and output it into a cell outside the chart?

Basically, I want to create a trendline outside a chart based on the range of the chart, but will update if the range in the chart is updated. I wonder if this can be done wihtin the worksheet itself without going into VB.

You can use LINEST() to get the parameters of a linear trendline, or other methods to get different types of fits.

Originally Posted by shg

You can use LINEST() to get the parameters of a linear trendline, or other methods to get different types of fits.

So this function depends on data. I have the data. The data is used in a chart. I want my trendline equations to change as a user changes the chart range wihtout having the user redefine the range for the trendline functions.

If you put a terndline in a chart, the trendline will change automatically in response to changing data. And you have the option of showing the parameters of the trendline on the chart.

If you want the parameters of the trendline external to the chart, you can use LINEST() to get the slope and intercept of the line, as well as other parameters. You can look at the trendline parameters on the chart and those computed with LINEST, and verify that they agree.

If the chart is plotting a dynamic range, then LINEST can refer to the same dynamic range. You can use the parameters LINEST returns to create your own trendline data series, and then plot it (or do anything else with it).

If you want to get the parameter of the trendline FROM THE CHART onto the worksheet, if it's possible (I haven't tried), it would require VBA, and might require parsing the data from the DataLabel object -- at a glance, I don't see properties that return the parameters directly.

If none of that answers your question, would you please restate it?

Originally Posted by shg

If you want to get the parameter of the trendline FROM THE CHART onto the worksheet, if it's possible (I haven't tried), it would require VBA, and might require parsing the data from the DataLabel object -- at a glance, I don't see properties that return the parameters directly.

If none of that answers your question, would you please restate it?

This answered it. The problem is my textbox in the chart isn't updating so I was trying a work around.