# Excel: Convert a Power Trendline into Data

Hi - hoping someone can help me, I'm really struggling! I have some data which I have plotted into a graph and created a power trend line. I want to have the data that creates the power trend line in a table. I have found formulas - but I just don't seem to be smart enough to put them into practice. Can anyone help me? This is my original data;

 DATA Quantity Price 100 70.07 200 101.33 300 215.6 400 280.19 500 283.51 500 62.52 1000 457.65 1000 457.65 1000 381.83 1000 295.37 1000 280.19 1500 338.49 1500 338.49 2000 458.15 2000 352.9 2000 332.02 2000 330.03 2550 267.34 3000 717.61 3000 555.17 3000 467.85 4000 1020.9 4000 773.65 4900 562.16 6000 365.44 8000 512.05 50000 1293.6
This is my graph with power trend line. -- removed inline image --- This is the table that I want to complete with the trend line data (up to 50,000)
 Quantity Price 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
This is the equation that I found;
 Equation: y=c*x^b c: =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2)) b: =INDEX(LINEST(LN(y),LN(x),,),1)
Can anyone help me put this into practice?