How to Make a Graph in Google Sheets: A Step-by-Step Guide

Creating a graph in Google Sheets is a quick and simple process. First, open your Google Sheets document and highlight the data you want to include in your graph. Then, click on the ‘Insert’ menu and select ‘Chart’. A chart will automatically be generated, which you can then customize to your liking.

Once you’ve made your graph, you’ll be able to visualize your data in a way that is easy to understand and share with others.


Graphs and charts are essential tools for data visualization. They help us to see patterns, trends, and correlations that might not be obvious from looking at raw data. In business, education, and personal projects, having the ability to create graphs quickly and easily is invaluable. That’s where Google Sheets comes in.

As one of the most popular spreadsheet tools, Google Sheets offers a user-friendly interface and a range of features to help you manage and visualize data. What’s great about Google Sheets is that it’s accessible from any device with an internet connection and a web browser. Whether you’re a teacher looking to create graphs for your students, a business analyst presenting data to stakeholders, or someone working on a personal project, knowing how to make a graph in Google Sheets will serve you well.

Related: How to Create Google Sheets PDF Files

Step by Step Tutorial: How to Make a Graph in Google Sheets

The following steps will guide you through the process of creating a graph in Google Sheets.

Step 1: Select Your Data

Highlight the cells that contain the data you want to include in your graph.

Selecting the correct data range is crucial for an accurate representation of your graph. Ensure that you include both the data points and their corresponding labels.

Step 2: Insert a Chart

Click on the ‘Insert’ menu, then choose ‘Chart’.

After clicking ‘Chart’, Google Sheets will automatically generate a chart based on the data you’ve selected. The default chart type is usually a column or bar chart, but this can be changed later.

Step 3: Customize Your Chart

Use the Chart Editor to customize the chart type, data range, and appearance.

The Chart Editor is where the magic happens. You can switch between different types of charts, add titles, change colors, and adjust other settings to make your graph look exactly the way you want.

Step 4: Position Your Chart

Drag your chart to the desired location on the sheet, or move it to a separate sheet.

Your chart is a floating object on your sheet, which means you can place it wherever it makes the most sense. If you’d rather have it on a separate sheet, simply right-click on the chart and select ‘Move to own sheet’.


Easy to UseGoogle Sheets’ user interface is intuitive, making it easy for even beginners to create graphs.
CustomizableThe Chart Editor offers a range of customization options, allowing you to make your graph fit your specific needs.
AccessibleAs a cloud-based tool, Google Sheets allows you to access and edit your graphs from anywhere, on any device.


Internet DependentTo use Google Sheets, you need a stable internet connection, which might not be available in all locations.
Limited FeaturesWhile Google Sheets has many features, it may lack some advanced charting options available in other software.
Potential for Data Privacy IssuesSince your data is stored in the cloud, there may be concerns about privacy and data security.

Additional Information

When working with Google Sheets, there are a few additional tips to keep in mind. First, always ensure your data is clean and organized before creating your graph. This will save you from encountering issues with your chart later on. Also, familiarize yourself with the different types of charts available. While pie charts are great for showing parts of a whole, line charts work best for displaying changes over time.

Don’t forget to explore the advanced options in the Chart Editor. You can add trendlines, error bars, and even create combo charts to present multiple data sets. Remember, the goal is to make your data as clear and impactful as possible, so take the time to format and design your graph appropriately.


  1. Select your data.
  2. Insert a chart.
  3. Customize your chart.
  4. Position your chart.

Frequently Asked Questions

Can I create a graph in Google Sheets on mobile?

Yes, you can create graphs in the Google Sheets app on mobile devices, although the features may be more limited than the desktop version.

Can I import a graph from Google Sheets to Google Docs?

Absolutely! You can easily insert a graph from Google Sheets into a Google Docs document by using the ‘Insert’ menu in Google Docs.

How do I change the chart type in Google Sheets?

You can change the chart type by selecting the chart and then choosing a different option from the ‘Chart type’ dropdown in the Chart Editor.

Is it possible to add a second data series to my graph?

Yes, you can add multiple data series to your graph by adjusting the data range in the Chart Editor to include additional columns or rows.

Can I export my Google Sheets graph as an image?

Indeed, you can export your graph by right-clicking on the chart and selecting ‘Save image’.


Knowing how to make a graph in Google Sheets empowers you to present your data in a visually appealing and understandable way. It’s a skill that’s useful across many contexts, be it in the professional realm or for personal projects. With the ease and accessibility of Google Sheets, you can turn those rows and columns of numbers into impactful, informative graphs.

Remember, the key to a successful graph in Google Sheets lies in selecting the right data, choosing the appropriate chart type, and customizing it to tell the story you want. So go ahead, give it a try, and watch your data come alive!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy