Changing trendline polynomial order

[c.davidson]

I have data ranges in a spread sheet for x and y that are also shown on a scatter chart, I have used an index(linest) function to get coefficients for the ranges and calculate a y value based on a given x. I use the chart to see how the values a forecast beyond the range. However sometimes as the data in the range changes the polynomial order of the coefficients need to change.

Is it possible to link the polynomial order of the trendline in my scatter chart to a cell so that when I change the polynomial order of the coefficients the chart also changes? Or is there VBA code that can do this when the cell changes? e.g. from polynomial order 2 to 3.

[lecxe]

Hi

Let's say you have a chart in Sheet1 named MyChart.

You added 1 polynomial trendline to its first series and you want its order to change to the value that you write in Sheet1!B1.

You can use:

Please Login or Register  to view this content.

If you want this to be automatic use a ChangeEvent to call this procedure whenever you change the value in B1.