How To Create A Line Graph In Google Sheets

How to create a line graph in google sheets

Google sheets are an alternative online Excel spreadsheet found in Googles’ web browser which allows users to key in data and does analysis just like in Microsoft excel. Its advantage is that unlike Microsoft Excel, your data is automatically saved in google drive thanks to the newly added macros hence no risk of losing data even when the power goes off. Besides, it has automated and simplified formulas to do calculations and perform other activities making it more viable. Furthermore, one can invite others to work on the spreadsheet with you. Also, it gives you the opportunity to make changes to the file without having to destroy the original document. When you are done making changes, you can simply download it where sheets are going to convert it back to excel files, ready to be used by Microsoft excel once again.

Most of the time when working with data on google sheets you will be required to create graphs to make your data more presentable, easy to understand and draw better conclusions. Organizations use graphs from previously analyzed data to make decisions on certain important issues affecting them. Researchers as well as use graphs to explain the prevalence of a certain problem as well as perform statistical predictions on the future of such issues. Google Sheets allows users to create graphs from their data through their chart features.

The chart feature in google sheets is a useful tool which can change a bulky data into a digestible format. Line graphs help analysts see the rates of change/ trends in certain data in a better and clear way.

In a simple and quick way, I will use screenshots to explain how to create a line graph in google sheets.

Steps for creating a line graph

1. First, ensure you have keyed in the right data in google sheets. Select the data to be used in the graph.

072320 2119 Howtocreate2

2. On the menu bar, click Insert and select Chart.

072320 2119 Howtocreate3

Google sheets automatically generate a graph as shown below.

072320 2119 Howtocreate4

3. On the right side of the screen, click Setup then selects the graph of your choice from a range of selections ranging from line graphs, bar graphs, scattered graphs, column graphs, etc.

072320 2119 Howtocreate5

In our case, change the type of graph to the line graph by clicking on the Line chart option.

072320 2119 Howtocreate6

Google sheets allow you to customize your chart further in the menu found in the dialogue box which shows when you double click inside the cart. This feature allows you to change the data range as well as switch columns and rows if applicable