Inputting a cells value into a trendline equation.

[jadif01]

I have managed to extract the trendline from a graph to a cell and now wish to input different values of x so I am able to plot more points. The values of x are already in a range of cells. I have managed to reduce the formula down to:

1.81ln*(x)+1.6161

to hopefully make it easier. I have values for x in one column and wish to work out subsequent values of y in another. I would like to learn how to do this in VBA as I want to create a Macro to do this so I am able to run it for different sets of data.

Any help would be greatly appreciated!

 

[oldbrewer]

column a = values of x column b = formula

A1 = G1 say
A2 = G1 + increment
A3=A2 + increment

increment could be in cell H1

this lets you rapidly put in different values of X

 

[jadif01]

Sorry, could you explain your answer a little clearer please?

 

[oldbrewer]

gives you a way of setting the range of x values ie the start value and the increment, your formula calculates the Y and you plot the graph.