<

How to Customize Graphs using Google Sheets

Published on
5,362 Points
2,162 Views
2 Endorsements
Last Modified:
Adding annotations and creating trendlines in Google Sheets can make your graph easier and clearer to understand. Use this guide to customize your charts.
 

Create Annotations

Annotations are useful for adding notes of observations or trends into your chart. They can label specific data points in your graph.

Follow these steps to add annotations:
 
  1. Enter in all your data into Google Sheets.
  2. For this example, Column A is my horizontal axis and Column B is my vertical axis. Add your notes or observations into Column C next to the corresponding data point.
  3. Highlight your data and select Insert graph1Create.png
  4. Using the Chart Editor, choose which type of graph you would like. I chose a line graph for this example. You can now see your notes that you have added into the chart. 2Insert.png
  5. Select Insert once you have finished.
  6. To customize your graph, choose Advanced edit in the drop-down menu on the top right hand corner of your graph.3AdvancedEdit.png
  7. Using the Chart Editor you can change the font, color and size of your annotations. 
    4Customize.png
 

Create Horizontal Annotations

Horizontal annotations are helpful for showing progression especially. Use the following steps to create horizontal annotations:
 
  1. Enter in all your data into Google Sheets.
  2. For this example, Column A is my horizontal axis and Column C is my vertical axis. Insert your notes into Column B.
  3. Highlight your data and select Insert graph5HorizontalCreate.png
  4. Choose which type of graph you would like using the Chart Editor. I chose an area graph for this example. You will now see your horizontal annotations in your graph.
  5. Select Insert once you have finished.6InsertHoriz.png
 

Create Trendlines

Follow these steps to create a trendline into your graph:
 
  1. Enter in all your data into Google Sheets.
  2. For this example, Column A is my horizontal axis and Column B is my vertical axis.
  3. Highlight your data and select Insert graph7TrendlineCreate.png
  4. Choose which kind of graph you would like. For trendlines, a scatterplot graph would be your best choice.8ScatterPlot.png
  5. Once you have created the graph, select Advanced edit from the drop-down menu on the top right hand corner of the graph. 9Advanced.png
  6. Under the customize tab, scroll down to Trendline and choose which kind of line you would like. I chose linear. 10Trendline.png
  7. You can then customize your trendline.11CustomizeTrendline.png
Hopefully this guide helps in customizing your graphs with annotations and trendlines. 
2
Comment
0 Comments

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

This Micro Tutorial demonstrates in Google Analytics how to create a custom report that shows you traffic over time using the month of year dimensions. There are also instructions on how to fix Google's odd month of year formatting, which Microsoft …
This Micro Tutorial will demonstrate how to use comments in Google Docs. You will learn how to create, edit, and delete a comment.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month