They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date polynomial-math trendline Share Improve this question Follow asked at 17:28 laxer 720 11 39 I just tested with Mathematica and the formula gives me the same result: f (3)1.3932. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

Still need help? Go to Microsoft Community.

In the Decimal places box, increase the number of decimal places to 30 so that you can see all the decimal places.

Select the Number tab, and then select Number in the Category list.

On the Format menu, click Selected Data Labels.

In the chart, select the trendline equation.

excel excel-formula trendline Share Improve this question Follow edited at 23:07 brettdj 54. So I would like to get x for the given y series. To work around this behavior, increase the digits in the trendline equation by increasing the number of decimal places that are displayed. Without switching axis on chart itself, what is the easy way to switch x and y for the given expression like y 3E-12x5 - 4E-09x4 + 1E-06x3 + 0.0005x2 - 0.0302x + 23.826. This can cause a trend to appear to be incorrect. However, the accuracy of the chart is significantly reduced.

This behavior allows the equation to occupy less space in the chart area. For appearance, each X value is rounded off to the number of significant digits that are displayed in the chart. Microsoft Excel plots trendlines incorrectly because the displayed equation may provide inaccurate results when you manually enter X values. Therefore, the trendline will be inaccurate if it is displayed on these types of charts. In these chart types, the X axis is plotted as only a linear series, regardless of what the labels actually are. Why not change the trend line equation insertion function so that it inserts a plain text box with the required text instead of a trend line. Line, Column, and Bar charts plot only the Y axis as values. This chart plots both the X axis and Y axis as values.

The trendline formula is used for an XY Scatter chart.

Excel trendline polynomial equation