A couple nice new features for Google Sheets users are rolling out today including the ability to copy and paste charts and a new trendlines feature.

Sometimes it’s helpful to recognize and track patterns of data in your spreadsheets, so that’s why today we’re launching trendlines to scatter plot, bar, column, and line graphs in Google Sheets. Trendlines are commonly used to analyze financial and scientific data, but they can even be useful in the classroom or for personal needs like budgeting.

There are a bunch of ways to customize trendlines in Sheets, like: -Choose between exponential or linear trendlines -Add a variety of labeling options -Customize your trendline

Today’s update also brings the ability to copy and paste charts in Sheets between other sheets or spreadsheets.

Google has more info on adding trendlines to charts here.

FTC: We use income earning auto affiliate links. More.

Check out 9to5Google on YouTube for more news:

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel

About the Author

Jordan Kahn

Jordan writes about all things Apple as Senior Editor of 9to5Mac, & contributes to 9to5Google, 9to5Toys, & Electrek.co. He also co-authors 9to5Mac’s weekly Logic Pros series and makes music as one half of Toronto-based Makamachine.