To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose Insert Trend Line Equation. When the chart is in edit mode, LibreOffice gives you the equation of the trend line and the coefficient of determination R 2, even if they are not shown: click on the trend line to see the information in the status bar. Trend Line Equation and Coefficient of Determination Its name can be defined in options of the trend line. Thanks a bunch for the help! You saved me a lot of gray hairs.A trend line is shown in the legend automatically. Decimal seperator is set to the right symbol so I got no clue. I think I can work with that but why the hell that happened is beyond me. Yeah, tried it myself and you seem to be right. All I need is a smooth curve which 'looks about right' so I can interpolate and get some rough calculations out. There are so many empirical laws and approximations behind these calculations that finding a theoretical physical relationship would be an absolute pipe dream. This is the reason why my two smaller polynomial approach failed. All I need is a curve that roughly fits but much more importantly needs to be fairly smooth since I'm doing some iterative calculations which dont converge if there is any break in continuity. These are data relating to the combustion of hybrid rocket motors and it's a real pain to obtain finer measurements. Thankfully I'm not doing any extrapolation. 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 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.

Excel trendline equation wrong