![]() However, unless you have a very old version of Excel, where the LINEST function did not work properly, it is usually simpler to just use worksheet functions for that purpose.įor example, if this is a line graph where y is your range of y-values your trendline is a 4th order polynomial, and your x-axis is just serial numbers 1. Sincerely, Jazlyn Microsoft Community Moderator. ![]() ![]() If my understanding is wrong, please feel free to post back. In the Category list, click Number, and then change the Decimal places setting to 3. Right-click the trendline equation, and then click Format Trendline Label. 4E+08 will be interpreted by Excel as being 4*10^8 or 400,000,000. Open the worksheet that contains the chart.You can use the trendline from a graph in an equation, but, in addition to translating it correctly, you need to also format the trendline to show a maximum number of decimals (e.g 15), else your results will not be congruent with the graph.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |