How To Use Google Sheets To Make A Line Graph

Select all three columns down to the last row of data.

How to use google sheets to make a line graph. Almeida explains how to make a chart specifically a double line graph in google sheets. Below are the steps to create a line combo chart in google sheets. With x as the x axis note that their x values aren t exactly the same. The chart option will give some random chart type for your selected data based on google machine learning suggestions. Create a google sheets graph with multiple lines in the same chart.

To make a line graph in google sheets from multiple sets of data the process is roughly the same. Change how the chart looks. Creating the line graph in google sheets highlight your whole data table ctrl a if you re on a pc or cmd a if you re on a mac and select insert chart from the menu. In the toolbar click on the insert chart icon or go to the insert option in the menu and then click on chart. You ll need to lay out the data in multiple columns again with the x axis data in the leftmost column.

As you can see in the below image we got histogram chart. After data selection go to the menu of google sheets and select insert and the chart. Create a line graph in google sheets. Click insert chart to create your chart and open the chart editor tool. To start open your google sheets spreadsheet and select the data you want to use to create your chart.

At this point your chart may look something as shown below. In the recommendations tab you ll see the line graph we re after in the top right of the selection. Jump into your google sheets and then enter the data that you want to use for your line chart. It can be the anything from the total valuation of two of the trillion dollar companies apple versus amazon and their prominent rise over a span of time or it can be the nba finals basketball game where the points scored over a game between the toronto raptors and golden state warriors. At the right click customize.

Double click the chart you want to change. By default a basic line chart is created using your data with the chart editor tool opening on the right to allow you to customize it further. To create the line graph from this data. Basically i want to have a line for bob a bob for bill etc. On your computer open a spreadsheet in google sheets.