Skip to content

Adding Trendlines to Charts in Google Sheets

< 1 minute read

Sheets Green

With Google Sheets, you can store data and visualize it with great looking charts, but you haven’t really been able to quickly identify trends in that data. That changed this week when Google finally introduced trendlines to charts in Google Sheets.

Trendlines are really easy to add to a chart and there are plenty of customization options available. You can apply a linear or exponential trendline, change the color and adjust the thickness and opacity.

As a bonus update, Google has also added the ability to copy/paste charts inside of Google Sheets. You can copy / paste from one sheet or spreadsheet to another, but the data will only be updated if it is in the same spreadsheet. Otherwise your chart will only reflect the data as it was originally copied.

Click here to watch this video on YouTube.

Sign up for our newsletter