How to Make a Graph in Google Sheets? in 2022 [Complete Guide]

By • Last Updated
How to Make a Graph in Google Sheets? in 2022 [Complete Guide]
Offered By
Category Sheet
Get it On GooglePlay
Updated August 10, 2022
MOD Features

Graphs are a great way to visualize data, and Google Sheets makes creating them a breeze. In this article, we’ll show you how to create a basic line graph in Google Sheets, and how to customize it to fit your needs.

Setting up your Google Sheet

Assuming you already have a Google account (if you don’t, setting one up is easy – visit and click “Sign In” in the top-right corner), open up Google Drive ( and create a new Sheet by clicking on the “+New” button in the top-left corner and selecting “Google Sheets”.

Now it’s time to start adding some data to your Sheet! In each cell, you can enter text, numbers, or formulas. For our purposes, we’re going to focus on adding numbers to create a basic graph.

Start by entering some labels for your data in cells A1 and B1 – something like “Date” and “Sales”, for example. Then, in cell A2, enter the first date you want to track. In the cell below that (A3), enter the next date. Continue adding dates down column A until you have a good amount of data – at least a few weeks’ worth.

In column B, next to each date in column A, enter the corresponding sales figures. So, if your first date was January 1st and you sold 10 items that day, you would enter “10” in

Creating your graph In Google Sheet

In Google Sheets, making a graph is a quick and easy way to visualize your data. To create a graph, follow these steps:

  • Select the data you want to include in your graph.
  • Click the Insert tab, then click on the type of graph you want to create.
  • Customize your graph as needed, then click Insert.

Your graph will now be inserted into your sheet!

Customizing your graph In Google Sheet

After you’ve created your graph in Google Sheets, you can further customize it to better suit your needs. To do this, simply click on the “Customize” tab in the top-right corner of the page.

From here, you can change the title and axis labels of your graph, as well as the colors and other appearance options. You can also add a trendline to your graph, which can be helpful in seeing overall trends in your data.

Once you’re happy with how your graph looks, simply click “Apply” to save your changes.


Making a graph in Google Sheets is a quick and easy way to visualize your data. With just a few clicks, you can create a beautiful and informative graph that will help you better understand your data.

We hope this tutorial has helped you learn how to make a graph in Google Sheets. If you have any questions, please feel free to leave them in the comments below.


Review & Discussion


Please read our comment policy before submitting your comment. Your email address will not be used or publish anywhere. You will only receive comment notifications if you opt to subscribe below.