Google updates sheets to allow inserting Trendlines

Today ladies and gentlemen I am happy and sad at the same time.  As many of you are aware, I created an "add on" for Google Sheets to allow for adding trendlines to graphed data.  I recently made version 2 public (here is link Trendline Add on Ver 2).  In this version I included the statistical analysis to include showing the "r^2" value as well as the slope and y intercept.

I just learned today that Google has updated Sheets to allow.... wait for it.....  adding trendlines to a chart!!!

Here is a link to a GoogleGooru video that discusses adding trendlines: Adding Trendlines to Charts

Something that the video did not cover is how to show the "r^2" value and the equation of the trendline.  The "r^2" value is easy: there is a box that you can select to show it.  To show the equation you need to select the "Label" dropdown and choose "Use equation".

So, I am a sad that Google added something that I spent a lot of time and energy working on... but happy that they did so!!!

Trendline Addon Version 2

After some long delays I am happy to announce that Version 2 of "Trendline Addon" has been made public! (To skip the rest of the post and get straight to it here is the link: Trendline Addon Ver2  Make a copy, open script editor and run "onInstall")

The most feedback I got from version one was the need for the "coefficient of determination" or the "r² "value.  After some trial and error I came up with a solution that I think will work just fine.  What happens is when you create a graph now you have the option to run a "linear regression analysis".  When this option is selected, an analysis is done and the results are placed on a hidden sheet called "STATS" and the important parts of the analysis (namely the slope, y-intercept and coefficient of determination) are then added to another sheet called "mbr^2".  If you unhide the "STATS" sheet you might want to look at "Google Sheets Linear Regression Info" to get an understanding of what all the numbers represent.

The stats and the data are connected.  So if you change your data the "STATS"and "mbr^2" sheets are updated appropriately.

Here are the basics steps to use Version 2:

1. Click the link, save a copy, 
2. Go to "Tools - Script Editor" and run either "On install" or "On open". This will add a menu command on your "Add ons" menu.  
3. Click "Create Graph" and follow the instruction in the sidebar!  

Please let me know what you think! I am working on how to add more trendline options such as power and exponential.  

List of links:

The spreadsheet:  Trendline Addon Ver2  

The original post: Adding a Trendline to a Google Sheets Chart