How to create bar chart 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.

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 Bar chart and adjust Customize options.

Related tutorials

These videos might help you go deeper on this topic.

Browse more tutorials
Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.
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 Duplicate a Tab and Move it to the End in Google Sheets

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far ...
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 ...

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 bar chart in 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 a bar chart 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 column chart 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 stacked bar chart 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 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 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 →

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.