How to create a 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 more 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.

The chart feature in google sheets is a useful tool which can change a bulky data into a digestible format.

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

Steps for creating a graph in google sheets

1. Select the data to be used in the graph.

072320 2054 Howtocreate2

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

072320 2054 Howtocreate3

Google sheets automatically generate a graph as shown below.

072320 2054 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.

072320 2054 Howtocreate5

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

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 chat feature.