Forum Discussion
Create line chart with subcategorizing the X axis[to reduce the data points]
One more query in the same lines. See in the below graph if I want to show 2 things :-
1) 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. The starting point of the graph should be starting from y = 10 and x =0 [start points]and Y =50 and X = around .78[End limits].How can I achieve it ?
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 is obviously an expontial series so it should be like y = e^2 x so how do I display this equation from the graph data as we do in excel sheet? 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 output and also I want to display the exponental equation associated with this graph because this is not a line graph exactly y = k e^2x (something like that )
Community SupportHi PBIBee321 ,
You can achieve this by directly resizing and setting it:
Change the X-axis format and resize the line chart
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
One more query in the same lines. See in the below graph if I want to show 2 things :-
1) 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. The starting point of the graph should be starting from y = 10 and x =0 [start points]and Y =50 and X = around .78[End limits].How can I achieve it ?
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 is obviously an expontial series so it should be like y = e^2 x so how do I display this equation from the graph data as we do in excel sheet? 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 output and also I want to display the exponental equation associated with this graph because this is not a line graph exactly y = k e^2x (something like that )