How to Make a Bar Graph in Google Docs

Published: . Last updated:

Applies to: Google Docs on a computer. Mobile limits are covered below.

Here's how to make a bar graph in Google Docs: on a computer, click Insert > Chart > Bar (or Column for vertical bars). Docs adds a sample chart linked to a new Google Sheet:

  1. Click the chart, then Link options > Open source.
  2. Replace the sample data in the Sheet.
  3. Back in Docs, click Update.

Want a chart you can drop into Docs as an image? Make it in the free bar graph maker.

On this page

Before you start: what a Docs chart really is

Google Docs doesn't store chart numbers inside the document. When you add a new chart, Google's own Help page says it "will link to a new Google Sheet," and to change the chart you "update the numbers in the Google Sheet" (Google Docs Editors Help, linked charts). So every bar graph you make in Docs is really a small spreadsheet plus a picture of its chart.

Two practical things follow from that:

  • Use a computer. Google's Help tells you to go to docs.google.com on a computer to add charts to a document (Google Docs Editors Help). The Docs phone and tablet apps are covered further down.
  • Expect a new file in your Drive. The linked Sheet is a separate file, and that's where your data lives.

Google renames menus from time to time. The steps below match Google's current Help pages. If a label looks different, look for the closest match.

Step by step: make a new bar graph

  1. Put your cursor where the chart should go. The chart is inserted at the cursor, like an image.
  2. Click Insert > Chart. Google's Workspace team describes it this way: go to Insert > Chart in Docs on the web, then insert a new chart or pick From Sheets (Google Workspace Updates).
  3. Choose Bar or Column. The chart menu offers Bar, Column, Line and Pie (Computerworld). Bar draws horizontal bars. Column draws vertical bars, which is what most school worksheets call a bar graph.
  4. Look at the sample chart. Docs fills it with placeholder data and creates the linked spreadsheet for you (Computerworld). Don't try to edit the numbers in Docs itself. That happens in the next section.

Not sure whether you want horizontal or vertical bars? Horizontal bars leave more room for long category names, like survey answers. Our guide to types of bar graphs shows both side by side.

Put your own data in the chart

  1. Click the chart in your document.
  2. Click Link options > Open source in the top right corner of the chart (Google Docs Editors Help). The linked Sheet opens in a new tab.
  3. Replace the sample data. Google's bar chart Help page explains the layout: the first column holds the labels, the other columns hold the numbers, and each row becomes a bar (Google Docs Editors Help, bar charts). Type your category names in column A and your values in column B. Change the header in B1 to name what you're counting.
  4. Style the chart in Sheets if you want. Double-click the chart in the Sheet and use the chart editor. Under Setup you can change the chart type and the data range, and you can add another range if your data is split up (Google Docs Editors Help, add and edit a chart). Titles, colors and axis labels are set in the same editor.
  5. Go back to the Doc and click Update. Changes in Sheets don't appear on their own. Click the chart, then click Update at its top right (Google Docs Editors Help; Computerworld).
Example data in the linked Sheet (example data)
Favorite fruitStudents
Apple8
Banana5
Grapes7
Orange4

That table, typed into columns A and B, gives you the four-bar chart below after you click Update.

If you delete rows from the sample data, check the chart's data range in the Sheet. Leftover empty rows can show up as blank bars.

Favorite fruit in one class (example data)Example column chart of favorite fruit: Apple 8, Banana 5, Grapes 7, Orange 4 students.FruitStudents012345678AppleBananaGrapesOrange8574
Favorite fruit in one class (example data)

Double bar graphs and stacked bars

Want to compare two groups, like two classes or two years? Add a second column of numbers next to the first one in the linked Sheet. Because every column after the first is treated as data (Google Docs Editors Help, bar charts), the chart shows two bars for each label, one per column, once the range includes both. Give each column a clear header, since those headers become the legend names.

For stacked bars, open the chart editor in the Sheet and look under Setup > Chart type (Google Docs Editors Help) for a stacked version of the bar or column chart. Exact option names may vary.

If you'd rather not touch a spreadsheet, the double bar graph maker and the stacked bar graph maker build these charts straight from a table you type or paste.

Favorite fruit in two classes (example data)Example double bar graph: Class A Apple 8, Banana 5, Grapes 7, Orange 4; Class B Apple 6, Banana 7, Grapes 3, Orange 6.Class AClass BFruitStudents012345678AppleBananaGrapesOrange86577346
Favorite fruit in two classes (example data)

Insert a chart you already made in Google Sheets

If your chart already exists in a Google Sheet, you don't need to rebuild it.

  1. In Docs, click Insert > Chart > From Sheets.
  2. Click the spreadsheet that holds the chart, then click Select.
  3. Click the chart you want to add.
  4. Leave Link to spreadsheet checked to keep it linked, or uncheck it for a static copy, then import it (Google Docs Editors Help).

Need help making that chart in the first place? See how to make a bar graph in Google Sheets.

Linked vs. unlinked charts

What changes when a chart is linked
LinkedUnlinked
Edit the numbersIn the source Sheet (Link options > Open source)No live connection to a Sheet
Refresh after changesClick Update on the chart, or Tools > Linked objects > Update allNothing to refresh
Good forReports whose numbers changeFinished work you want frozen

To unlink a chart later, click Link options in its top right corner and choose Unlink. Google also notes two things worth knowing: anyone with access to your document can see linked charts even without access to the original Sheet, and when you update, edits in the original file override changes made in the document (Google Docs Editors Help). Sharing a report with outside readers? Check what the chart shows before you send it.

Another way: make the chart here and insert it as an image

Sometimes the linked-Sheet setup is more than you need. Maybe you just want one clean chart for a class assignment, or you're on a school Chromebook and don't want an extra file in Drive. You can build the graph in our free bar graph maker, download it as a PNG, and drop it into Docs as a picture.

  1. Make your chart in the bar graph maker and download the PNG.
  2. In Google Docs, click Insert > Image > Upload from computer (Google Docs Editors Help, insert images).
  3. Pick the PNG file and click Open.
  4. Add a description for screen reader users: select the image, then click Image options > Alt text (Google Docs Editors Help, accessibility).

The trade-off is simple. An image won't update itself. If your numbers change, make the chart again and replace the picture. For a one-time chart, that's usually fine.

Alt text helps with linked charts too. One college accessibility guide suggests adding alt text or a small data table under the chart so screen reader users get the numbers (Elgin Community College).

On a phone or tablet, and other common snags

Phone or tablet
Google's Help sends you to a computer to add charts to a document (Google Docs Editors Help), and the iPhone and iPad version of Google's chart Help covers the Google Sheets app only (Google Docs Editors Help). One workaround: make the chart in the Sheets app, then add it to the Doc later from a computer with From Sheets. Or build it in the bar graph maker in your phone's browser and insert the saved image. App features change, so what you see may vary.
The chart didn't change after I edited the Sheet
Linked charts wait for you. Click the chart in Docs and click Update.
There's no Update button
The chart may be unlinked, or it was inserted as an image. Unlinked charts need to be inserted again from Sheets.
My labels are cut off
Switch from Column to Bar (horizontal) in the Sheet's chart editor, or shorten the labels.

Working in Microsoft Word or Excel instead? The steps are different, so see how to make a bar graph in Excel.

If you just want a finished bar graph without the linked spreadsheet, type or paste your numbers into the free bar graph maker, download the PNG, and insert it into your Doc in a few clicks.

Related guides

Frequently asked questions

Can you make a bar graph in Google Docs on your phone?

Not directly in the Docs app, based on Google's Help, which tells you to use docs.google.com on a computer to add charts to a document (Google Docs Editors Help). You can make a chart in the Google Sheets app, or make an image of one in your phone's browser, and add it to the Doc.

How do I edit the data in a Google Docs chart?

Click the chart, choose Link options > Open source, change the numbers in the Google Sheet that opens, then return to Docs and click Update on the chart (Google Docs Editors Help).

How do you make a double bar graph in Google Docs?

Insert a bar or column chart, open its source Sheet, and add a second column of numbers with its own header. Each data column becomes its own set of bars (Google Docs Editors Help, bar charts). Click Update in Docs to see it.

What's the difference between Bar and Column in Google Docs?

Both are bar graphs. Bar draws the bars horizontally, and Column draws them vertically. Pick Bar when your category names are long.

Why doesn't my chart update when I change the spreadsheet?

Linked charts in Docs refresh only when you click Update on the chart, or Tools > Linked objects > Update all. If there's no Update option, the chart isn't linked (Google Docs Editors Help).

How this page is checked

I wrote this guide around one fact from Google's own Help: a chart in Docs is a linked Google Sheet, so the numbers live in a separate file in Drive. I checked the Insert, Chart path, the From Sheets option and the Update button against Google's pages on linking charts and on bar charts. The phone and tablet advice follows what Google's Help says about the Android app and about the iPhone and iPad Sheets app, and the insert-as-an-image route follows the Help page on inserting images. The Workspace Updates announcement and the Computerworld walkthrough are outside descriptions of the same menu path, and the Elgin Community College page is where the alt text tip comes from. If Google renames a label, I change the step and the date at the top of the page.

Sources used on this page: