How to create graph Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Steps

  1. 1

    Arrange categories and numbers in adjacent columns.

  2. 2

    Select the range including headers.

  3. 3

    Choose Insert → Chart.

  4. 4

    Set Chart type to the chart type you need and adjust Customize options.

Related tutorials

These videos might help you go deeper on this topic.

Browse more tutorials
10 Google Sheets I Wish Someone Would Make

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is...
5 Ways To Use Google Sheets for Advanced Project Management

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Man...
Create Square Cells for Dashboards or Beautiful Information

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to ...
Ultimate Checklist in Google Sheets

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with...

Related blog posts

Written guides that go deeper on this question.

Browse the blog

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

Search channel

No exact channel match cached for “How to create graph Google Sheets” yet. Search Better Sheets on YouTube.

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

Related questions

How to create graph in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to create a graph in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to the chart type you need. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to create line graph in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to create bar graph in Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Bar chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

How to create a bar graph on Google Sheets

Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Bar chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.

Get the answer →

Need more than a quick answer?

636+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.

Need one fix

Watch a free tutorial for the step-by-step version of any answer.

Learning Sheets for real

Unlock the full library, generators, and templates with membership.