Trendline & R²



In datapine, you can add a variety of trend lines to the data points in your chart including linear, exponential, logarithmic, power and polynomial trend lines. The following guide will show you how to visualize trends in a few and easy steps and how to do regression analysis in datapine.



Display Trendline, Trend Fit and Equation


Open the Chart Creator with a click on Analyze in the upper navigation bar. Create your chart using the fields from your data source.


  1. To add a trendline to your data set, click on the data series in your chart to open the style options for this series on the right.
  2. At the bottom of the options you find TRENDLINE. Click the toggle to enable the trendlines for this data series.
  3. This will display a dropdown menu with a selection of trendline functions to choose from. Select the type of trend line you wish to use for your chart. You may choose between linear, exponential, logarithmic, power, polynomial or the best fit line that automatically uses the function with the lowest R2 value.
  4. You can now choose to add the trendline to the legend and to display the trend fit or equation as well.



How to add a tren line to a chart in analyzer




Types of Trendlines


datapine offers a variety of trendlines to choose from. Please find below the list of trendlines and explanations that datapine offers.





An exponential trendline is a curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trendline of your data which contains zero or negative values.


exponential trend line example





The linear trendline is a straight line that is used with simple linear data sets. Your data is linear if the pattern of its data points resembles a line. A linear trend line usually indicates a steady growth or decrease in your data.


linear trend line example





A logarithmic trendline is a best-fit curve that is most useful when the rate of change between one unit of your data increases or decreases quickly and then levels out. A logarithmic trendline can be used when having positive and negative values.


logarithmic trend line example





A polynomial trend line is a form of linear regression used when data fluctuates. Use this type of regressions when analyzing gains and losses over larger data sets to adjust the trend to the fluctuations. The order of the polynomials determines the number of ups and downs in your curve. Choosing an order 2 usually has only one fluctuation, order 3 has two hills or valleys and order 4 contains already 3 fluctuations.


polynomial trend line example





A power trendline is a curved line that is best used for data sets that compare measurements that increase at a specific rate. Power regressions will not allow a negative input value or an input value of zero.


power trend line example



Best Fit Line


The best fit line will automatically choose the best trend function for your data with the lowest R2 value.