# How to generate data points dynamically from power trendline

#### JenniferMurphy

##### Well-known Member
I have some data that I know follows a power curve. I have plotted the data, generated a trendline, and have the power function displayed on the chart. Here's the current set of data and the displayed trendline equation. The value "0.01" in H2 is a temporary value because Excel's power function curve fitting algorithm cannot handle zeroes. (sigh)

 A B C D E F G H 1 N 1 2 3 4 5 6 7 2 Actual Tally 122 43 14 6 1 1 0.01

<tbody>
</tbody>

y=798.59e-1.371x

As I run each trial, I add to the corresponding tally. For example, if the next trial results in a Value of "3", I will increment D2 from 14 to 15.

I would like to add a new row (3) that wold show the expected tally as computed by the trendline. And I would like that data to be dynamically and automatically updated when I update a value.

 A B C D E F G H 1 N 1 2 3 4 5 6 7 2 Actual Tally 122 43 14 6 1 1 0.01 3 Expected Tally ?? ?? ?? ?? ?? ?? ??

<tbody>
</tbody>

Is there any way to do this that might be simple enough for me to understand?

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Try this:

#### JenniferMurphy

##### Well-known Member
Try this:

Wow. That works! I would never have figured that out by myself. Thanks so much.

Replies
3
Views
242
Replies
3
Views
57
Replies
0
Views
307
Replies
0
Views
76
Replies
3
Views
328

1,129,874
Messages
5,638,781
Members
417,052
Latest member
Noobest

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back