Exponential graph -Line chart with trendline issue

[PBIBee321]

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:

X	Y
0.00304	101.2
0.00608	101.2
0.00912	101.2
0.01216	101.2
0.0152	101.2
0.01824	101.2
0.02128	101.2
0.02432	101.2
0.02736	101.2
0.0304	101.2
0.03344	101.2
0.03648	101.2
0.03952	101.2
0.04256	101.2
0.0456	101.2
0.04864	101.2
0.05168	101.2
0.05472	101.2
0.05776	101.2
0.0608	101.2
0.06384	101.2
0.06688	101.2
0.06992	101.2
0.07296	101.2
0.076	101.2
0.07904	101.2
0.08208	101.2
0.08512	101.2
0.08816	101.2
0.0912	101.2
0.09424	101.2
0.09728	101.2
0.1003	101.2
0.1034	101.2
0.1064	101.2
0.1094	101.2
0.1125	101.2
0.1155	101.2
0.1186	102
0.1216	101.2
0.1246	102
0.1277	102
0.1307	102
0.1338	102
0.1368	102
0.1398	102
0.1429	102
0.1459	102
0.149	102
0.152	102
0.155	102
0.1581	102
0.1611	102
0.1642	102
0.1672	102
0.1702	102
0.1733	102
0.1763	102
0.1794	102
0.1824	102
0.1854	102
0.1885	102
0.1915	102
0.1946	102
0.1976	102
0.2006	102
0.2037	102
0.2067	102
0.2098	102
0.2128	102.7
0.2158	102.7
0.2189	102.7
0.2219	102.7
0.225	102.7
0.228	102.7
0.231	102.7
0.2341	102.7
0.2371	102.7
0.2402	102.7
0.2432	102.7
0.2462	102.7
0.2493	102.7
0.2523	102.7
0.2554	102.7
0.2584	102.7
0.2614	102.7
0.2645	102.7
0.2675	102.7
0.2706	103.5
0.2736	103.5
0.2766	103.5
0.2797	103.5
0.2827	103.5
0.2858	103.5
0.2888	103.5
0.2918	103.5
0.2949	103.5
0.2979	103.5
0.301	103.5
0.304	103.5
0.307	103.5
0.3101	103.5
0.3131	103.5
0.3162	103.5
0.3192	103.5
0.3222	104.3
0.3253	104.3
0.3283	104.3
0.3314	104.3
0.3344	104.3
0.3374	104.3
0.3405	104.3
0.3435	104.3
0.3466	104.3
0.3496	104.3
0.3526	105.1
0.3557	105.1
0.3587	105.1
0.3618	105.1
0.3648	105.1
0.3678	105.1
0.3709	105.1
0.3739	105.1
0.377	105.1
0.38	105.1
0.383	105.1
0.3861	105.1
0.3891	105.1
0.3922	105.9
0.3952	105.9
0.3982	105.9
0.4013	105.9
0.4043	105.9
0.4074	105.9
0.4104	105.9
0.4134	105.9
0.4165	106.7
0.4195	106.7
0.4226	106.7
0.4256	106.7
0.4286	106.7
0.4317	106.7
0.4347	106.7
0.4377	106.7
0.4408	106.7
0.4438	107.5
0.4469	107.5
0.4499	107.5
0.4529	107.5
0.456	108.2
0.459	107.5
0.4621	108.2
0.4651	108.2
0.4681	108.2
0.4712	108.2
0.4742	108.2
0.4773	109
0.4803	109
0.4833	109
0.4864	109
0.4894	109
0.4925	109
0.4955	109
0.4985	109.8
0.5016	109.8
0.5046	109.8
0.5077	109.8
0.5107	110.6
0.5137	110.6
0.5168	110.6
0.5198	111.4
0.5229	111.4
0.5259	111.4
0.5289	111.4
0.532	111.4
0.535	112.2
0.5381	112.2
0.5411	112.2
0.5441	112.2
0.5472	112.2
0.5502	112.2
0.5533	112.2
0.5563	112.2
0.5593	112.2
0.5624	112.2
0.5654	112.2
0.5685	113.7
0.5715	113.7
0.5745	114.5
0.5776	114.5
0.5806	114.5
0.5837	115.3
0.5867	115.3
0.5897	115.3
0.5928	116.1
0.5958	116.1
0.5989	116.1
0.6019	116.1
0.6049	116.1
0.608	117.6
0.611	117.6
0.6141	117.6
0.6171	117.6
0.6201	118.4
0.6232	118.4
0.6262	119.2
0.6293	119.2
0.6323	119.2
0.6353	120
0.6384	120
0.6414	120.8
0.6445	120.8
0.6475	121.6
0.6505	121.6
0.6536	121.6
0.6566	121.6
0.6597	122.4
0.6627	122.4
0.6657	123.1
0.6688	123.1
0.6718	123.1
0.6749	123.9
0.6779	123.1
0.6809	123.9
0.684	123.9
0.687	124.7
0.6901	125.5
0.6931	125.5
0.6961	125.5
0.6992	126.3
0.7022	127.1
0.7053	127.1
0.7083	127.1
0.7113	127.8
0.7144	127.8
0.7174	127.8
0.7205	128.6
0.7235	128.6
0.7265	129.4
0.7296	129.4
0.7326	129.4
0.7357	129.4
0.7387	130.2
0.7417	130.2
0.7448	131
0.7478	131
0.7509	131.8
0.7539	131.8
0.7569	131.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

[v-luwang-msft · Accepted solution]

Hi @PBIBee321 ,

Try to adjust the below:

Best Regards

Lucien