How to Make a Line Graph with Multiple Lines The above steps would change the existing chart (which is not a line chart) into a line chart. In the Chart type drop-down, select the Line chart option.In the Chart editor pane, click on Setup (if not selected already).This will open the ‘Chart editor’ pane on the right Click on the three dots that appear at the top-right part of the chart.Select the chart that you want to change into a line chart.In case you don’t get a line chart, you can easily change it and get the line graph instead.īelow are the steps to change any other chart type into a line chart: Google tries to understand the data and gives you the best chart (which it thinks is the best visualization for the data). With the above dataset, Google Sheets automatically inserts a line chart, but that may not always happen. The above steps would insert the line graph in the worksheet in Google Sheets (as shown below). In the toolbar, click on the ‘Insert chart’ icon (or go to the Insert option in the menu and then click on Chart).
Select the data-set (you can also just select any cell within the dataset).This means that the line chart would only have one single line.įor the purpose of this tutorial, I will use the below dataset to make a line graph in Google Sheets.īelow are the steps to insert a line chart using the above data: Let’s first look at how to create a simple line chart, where we only have one data series. How to Make a Simple Line Graph in Google Sheets Making a Combination Line Chart (combo of line and column).How to Make a Line Graph with Multiple Lines.How to Make a Simple Line Graph in Google Sheets.
0 kommentar(er)
