How to Insert Line Graph in Google Sheets

You must be familiar with pie charts and column charts but do you know that you can also insert line graphs in Google sheets?

Let us elaborate more on this topic for you. You mostly use a line chart in your documents when you want to find trends in data over time. For instance, to get trends in sales or profit margins each month, quarter, or year. You can also insert a stock chart in Google sheets for a more effective data representation. Find out how to add a line graph in Google sheets in 7 simple steps.

Create Line Graph in Google Sheets

Insert Line Graph in Google Sheets in 7 Steps

Step-1 Start Google Sheets: If you want to open an existing Google sheet that you have already created, in which you want to insert line graph, then the best way is to use the link of the sheet.

We have explained the steps briefly below for a better understanding of yours:

• Start your web browser.
• Then, paste the link of the Google sheet that you might have copied earlier.
• Now, just click on the ‘Search’ icon to open it.

Step-2 Select Your Data: In this step, you have to select the data that you want in your line graph.

When you select the data then, it will look like the picture below.

Step-3 Click On the 'Insert' Menu: Then, you have to click on the 'Insert' from the topmost menu bar because you want to insert the line graph in your spreadsheet.

The Insert tab contains a list of all the possible things that you can insert or add to your sheet like charts, tables, pictures, etc.

Step-4 Choose The 'Chart' Option: in the list menu of the Insert tab, you will get various options like:

• Cells
• Rows
• Columns
• Sheet
• Chart
• Pivot table
• Image
• Drawing and other things.

The line graph that you want to insert, comes under the 'Chart' option. So, just click on the 'Chart' option.

Step-5 Click Here to Select Chart Type: A chart editor will now open up on the right hand side of your screen.

In the setup section of the chart editor, the first heading is of the 'Chart Type'. You have to click on the place where it is written 'stacked column chart'. You can see the picture below for reference.

Step-6 Select Line Chart: Now, you have to do these two things as we have mentioned below:

• First, scroll down in the list of options of various charts.
• Then, select the 'Line chart' which is the first option.

Step-7 Now The Line Graph is Added: Now, your line graph is added to your spreadsheet with all the data. You can edit it in any way you want with the help of the options available to you.

FAQ

How Can I Make an XY Line Graph in Google Sheets?

The steps given below will help you find out how to make an XY line graph in Google sheets:

• Open up your Google spreadsheet.
• Then, go to the 'Insert' menu.
• After that, you have to open the dropdown menu for 'Chart' type in the list.,
• Then, just scroll down until you find the 'Scatter chart' option.
• Select the 'Scatter chart' option and your data will convert to an x-y graph.

How Can I Make a Line Graph in Google Sheets with Two Sets of Data?

You can do it in the following steps:

• In your Google sheet, first of all, you have to select the entire range that you have entered data in your cells. This is the data that you want to display in the form of a line graph.
• This data also includes the headers.
• Then, after selecting the data, you have to open the 'Insert' menu.
• Choose the 'Chart' option.
• In the Chart Editor sidebar of the 'Setup' section, see the Chart Type.
• Then, from there select the type of graph that you want.
• You will now notice that the chart is displaying both data sets.

Is It Possible To Create graphs in Google Docs Too?

Most of the functions and functionalities of Google docs are the same as those of Google sheets. Just like you can print Google sheets, you can do that in docs too.

So yes, just like Google sheets it is possible to create starting Google docs too. The process of doing this is also not very complex.

You can easily create several different types of graphs and charts in Google Docs. The type ranges from the most basic line and bars charts for Google docs for beginners to use. And also to more complex graphs and charts like candlestick and radar charts.

Another method

Spreadsheets can be extremely useful tools in themselves, but at a certain point, all that data can just be too much to work with and understand. That's when a chart or graph can help clarify things and help you make a fair judgment by just looking at them. If you use Google Sheets, you can easily Insert a Line Graph in Google Sheets in just a few simple steps.

Following are the steps you may follow on How to Insert Line Graphs in Google Sheets.

Insert Line Graph in Google Sheets: 6 Steps 

Step 1 - Open the google sheets app: Google Sheets is a powerful cloud-based spreadsheet program that allows you to create complex spreadsheets. Look for the Google Sheets icon on your mobile device.

• It appears to be a green A4 sheet of paper with a fold in the top-right corner.
• It is surrounded by white-defined cells. If you can't find it, go to the Google Play Store and download it.
• In the search field, type 'Google Sheets.' Install and open it after you've found it.

Step 2 - Tap on any cell: After you have opened the google sheets application, and are on the particular spreadsheet you want to add the line graph to, select the cell you want to add the graph to. For selecting the cell, just navigate to that cell, and tap on it. To be sure whether the cell is selected or not, look for a blue rectangle around the cell.

 Step 3 - Tap on the + icon present in the top corner: After you select the cell you want to add the chart to, just tap on the + symbol that appears on the top corner of the interface. You may also tap on the "Insert" option depending on the version of google sheets you are using.

• This will open a drop-down menu with many options like "comment", "Link", etc.
• which you can use to add a comment to the cell or add different types of charts respectively.

Step 4 - click on chart: Hit on the "Chart" option in the drop-down menu. This will help create different types of charts and graphs, like line graphs, column charts, pie charts, etc in the sheets.

• Charts make it easy to visualize the data and properly analyze it.
• Instead of going through a whole lot of numbers you can just observe the chart and make a fare judgment.

Step 5 - Select the chart type: You may now choose which sort of chart you want to include in the document. The chart type you use is determined on the data set you're working with.

• Use a pie chart for relative comparisons and bar charts for precise comparisons if you wish to compare values.
• You can also use an area chart or a bubble chart to compare quantities.
• Use a line chart, bar chart, or scatter plot to demonstrate trends and patterns in your data.

Step 6 - Select any line chart: Line charts further have some different variations. We have simple line charts, smooth line charts, and combo line charts. Select the charts depending on the data set.

Conclusion

In conclusion, charts are visual summaries of our data. It's much easier to find meaning in a beautifully illustrated pie chart or bar graph than a list of data. Above all, a well-placed chart in your presentation can help you make your point clearer and help make everyone to understand your data. Adding charts to the sheet is a very easy 6-step process from opening the sheets app and selecting the type of chart you want on your sheets.