“Trendlines” are used to map out the trajectory of your graphs.

“Trendlines” are used to find the “Slope” of a line graph, which will help you see any trends in the trajectory of your chart, hence the name, “Trendline”.

I will show you a simple step-by-step process for displaying a Trendline on your graph. This will hopefully optimize your current line graphs.

Step #1: Access “Edit Chart”

Trendline Step 1

When you wave your cursor over your line graph, you should see three vertical dots. Click that, and you will open a dropdown menu for various commands for your chart.

You will click the option titled “Edit Chart”. That will take you to the “Chart Editor” toolkit.

Step #2: Access the “Series” Tab

Trendline Step 2

In the Chart Editor, you will see a lot of options. Simply click “Customize” and then select “Series”. From there, you will be able to apply and customize your Trendlines.

Step #3: Select “Trendline”

Trendline Step 3

Near the bottom of the “Series” category, you will find the “Trendline” option. Once you activate it, it will automatically apply the Trendline to your data, showing you the trajectory of your chart.

There are also many options on how you can choose to personalize and improve your trendline, such as:

  • Show the slope’s numerical value.

  • Edit the Color and Appearance of the Trendline

  • Assign and Display a Title

And there you have it; that is how you add a Trendline to your graphs.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!