Quick Links
Summary
First, add a chart to your Google sheet. you’re able to then edit the chart—in the Chart Editor, select the “Customize” tab in the sidebar, select “Series,” check the “Trendline” box, and customize your trendline’s settings.
If you want a simple visual to help your audience see the direction of the data in your chart, consider a trendline. You canadd different types of trendlinesin Google Sheets and customize their appearance.
About Trendlines in Google Sheets
You can add a trendline to abar graph, column chart,line graph, or scatter chart. You can select a specific series for the trendline or apply one to all the series in the chart.
Related:How to Make a Bar Graph in Google Sheets
There are six types of trendlines you may use depending on how you want to display the line:
Add a Trendline in Google Sheets
Once youhave the chartyou want to use and are ready to add the trendline, double-click the chart or click the three dots on the top right and select “Edit Chart” to open the Chart Editor sidebar.
Go to the Customize tab in the sidebar and expand the Series section.
At the top of the section, use the drop-down box to choose the series you want to use for the trendline. You can choose “Apply to All Series” or select a particular one in your chart.
If you want to customize a trendline for each series, simply select one at a time and follow the steps below for each.
Scroll to the bottom of the Series section and check the box for Trendline.
You’ll see the trendline appear on your chart. From there, use the Type drop-down box directly beneath to select the kind of trendline you want to use.
If you select Polynomial, you can pick the degree. If you select Moving Average, you can pick the Average Type and Period.
Once you have your trendline set up, you’re able to customize its appearance.
Customize a Trendline in Your Chart
With the Chart Editorsidebar open and the Series section expanded on the Customize tab, you’ll see options to customize the trendline.
Related:How to Switch Chart Axes in Google Sheets
You can select a Line Color using the palette drop-down box. This is handy if you want the trendline to stand out.
Next, you’re able to adjust the Line Opacity using the drop-down box. Pick from zero to 100% to make the line more or less bold.
You can then pick the Line Thickness using the drop-down box. Select one, two, four, or eight pixels for the width of the line.
Finally, you can add a label for your trendline to the chart legend if you like. Select the type in the Label drop-down box. If you choose “Custom,” enter the text for the label in the next box.
You can also choose “Use Equation” to display the trendline type’s equation as the label and optionally display the R squared for how closely the trendline fits the chart data.
When you finish adding and customizing your trendline, use the “X” on the top right of the Chart Editor sidebar to close it.
If you want an added visual to help your viewers capture the direction of your data, a trendline in Google Sheets is the way to go.
For more, check out how tosave or publish a chartor learn how tomake a table using a chartin Google Sheets.
