Forum Discussion

PBIBee321's avatar
PBIBee321
Regular Visitor
3 years ago
Solved

Exponential graph -Line chart with trendline issue

Hi All,

 

I need to draw a line graph with a trendline and equation of the graph and if I want to show 2 below stated points :-

 

1) I want to show Y axis as a scale of 0,5,10,15,20,25,30,35,40,45,50 instead of 100,105,110,115,120,125,130,135 as per the below screenshot. How can I achieve it ? Let X scale be the same 0,0.2,0.4,0.6,0.8 but Y  should be scaled down to 0,5,15,20,25,30,35,40,45,50. The starting point of the graph should be from y = 10 and x =0 [start point]and Y =50 and X = around .78[End limits]

 

2) I want to show a trendline for the chart? How can I achieve it and the relation of Y with X axis because this line graph is obviously an exponential series so it should be somewhat like y = e^2 x .  I want to display this equation from the graph data as we do in excel sheet? Is there a way to evaluate the equation of my graph based on the data .

 

Your input is welcome .

Input source:

XY
0.00304101.2
0.00608101.2
0.00912101.2
0.01216101.2
0.0152101.2
0.01824101.2
0.02128101.2
0.02432101.2
0.02736101.2
0.0304101.2
0.03344101.2
0.03648101.2
0.03952101.2
0.04256101.2
0.0456101.2
0.04864101.2
0.05168101.2
0.05472101.2
0.05776101.2
0.0608101.2
0.06384101.2
0.06688101.2
0.06992101.2
0.07296101.2
0.076101.2
0.07904101.2
0.08208101.2
0.08512101.2
0.08816101.2
0.0912101.2
0.09424101.2
0.09728101.2
0.1003101.2
0.1034101.2
0.1064101.2
0.1094101.2
0.1125101.2
0.1155101.2
0.1186102
0.1216101.2
0.1246102
0.1277102
0.1307102
0.1338102
0.1368102
0.1398102
0.1429102
0.1459102
0.149102
0.152102
0.155102
0.1581102
0.1611102
0.1642102
0.1672102
0.1702102
0.1733102
0.1763102
0.1794102
0.1824102
0.1854102
0.1885102
0.1915102
0.1946102
0.1976102
0.2006102
0.2037102
0.2067102
0.2098102
0.2128102.7
0.2158102.7
0.2189102.7
0.2219102.7
0.225102.7
0.228102.7
0.231102.7
0.2341102.7
0.2371102.7
0.2402102.7
0.2432102.7
0.2462102.7
0.2493102.7
0.2523102.7
0.2554102.7
0.2584102.7
0.2614102.7
0.2645102.7
0.2675102.7
0.2706103.5
0.2736103.5
0.2766103.5
0.2797103.5
0.2827103.5
0.2858103.5
0.2888103.5
0.2918103.5
0.2949103.5
0.2979103.5
0.301103.5
0.304103.5
0.307103.5
0.3101103.5
0.3131103.5
0.3162103.5
0.3192103.5
0.3222104.3
0.3253104.3
0.3283104.3
0.3314104.3
0.3344104.3
0.3374104.3
0.3405104.3
0.3435104.3
0.3466104.3
0.3496104.3
0.3526105.1
0.3557105.1
0.3587105.1
0.3618105.1
0.3648105.1
0.3678105.1
0.3709105.1
0.3739105.1
0.377105.1
0.38105.1
0.383105.1
0.3861105.1
0.3891105.1
0.3922105.9
0.3952105.9
0.3982105.9
0.4013105.9
0.4043105.9
0.4074105.9
0.4104105.9
0.4134105.9
0.4165106.7
0.4195106.7
0.4226106.7
0.4256106.7
0.4286106.7
0.4317106.7
0.4347106.7
0.4377106.7
0.4408106.7
0.4438107.5
0.4469107.5
0.4499107.5
0.4529107.5
0.456108.2
0.459107.5
0.4621108.2
0.4651108.2
0.4681108.2
0.4712108.2
0.4742108.2
0.4773109
0.4803109
0.4833109
0.4864109
0.4894109
0.4925109
0.4955109
0.4985109.8
0.5016109.8
0.5046109.8
0.5077109.8
0.5107110.6
0.5137110.6
0.5168110.6
0.5198111.4
0.5229111.4
0.5259111.4
0.5289111.4
0.532111.4
0.535112.2
0.5381112.2
0.5411112.2
0.5441112.2
0.5472112.2
0.5502112.2
0.5533112.2
0.5563112.2
0.5593112.2
0.5624112.2
0.5654112.2
0.5685113.7
0.5715113.7
0.5745114.5
0.5776114.5
0.5806114.5
0.5837115.3
0.5867115.3
0.5897115.3
0.5928116.1
0.5958116.1
0.5989116.1
0.6019116.1
0.6049116.1
0.608117.6
0.611117.6
0.6141117.6
0.6171117.6
0.6201118.4
0.6232118.4
0.6262119.2
0.6293119.2
0.6323119.2
0.6353120
0.6384120
0.6414120.8
0.6445120.8
0.6475121.6
0.6505121.6
0.6536121.6
0.6566121.6
0.6597122.4
0.6627122.4
0.6657123.1
0.6688123.1
0.6718123.1
0.6749123.9
0.6779123.1
0.6809123.9
0.684123.9
0.687124.7
0.6901125.5
0.6931125.5
0.6961125.5
0.6992126.3
0.7022127.1
0.7053127.1
0.7083127.1
0.7113127.8
0.7144127.8
0.7174127.8
0.7205128.6
0.7235128.6
0.7265129.4
0.7296129.4
0.7326129.4
0.7357129.4
0.7387130.2
0.7417130.2
0.7448131
0.7478131
0.7509131.8
0.7539131.8
0.7569131.8

Present visual:

 

Expected visual:

 Also display the exponential equation of the line series because this doesnt seem to be a straight line equation Y = mx+c

 

regards

gutthu

Need Help

1 Reply