How to Create a Graph in Google Docs

Updated 15 November 2026 · Standard formula, shown below

This guide walks you through inserting and customizing a chart directly in Google Docs, so you can add a visual summary of data to your report, proposal, or study notes without switching to another tool. You’ll learn how to create a chart from scratch, edit its data, and adjust its appearance. No prior experience is needed, but you should have a Google account and be signed in to Google Docs.

What You’ll Need

A Google account (free) with access to Google Docs.
A document open in Google Docs where you want the graph.
Your data ready in a simple table format (e.g., categories and values).

Step-by-Step

Open your Google Docs document. Go to docs.google.com and open the document where you want the graph, or create a new one by clicking the + Blank button.
Place your cursor where you want the graph to appear. Click at that spot in the document.
Insert a chart. In the top menu, click Insert > Chart. You’ll see several options: Bar, Column, Line, Pie, and From Sheets. Choose the type that best represents your data. For this guide, we’ll use Column as an example.
A default chart appears. Google Docs inserts a sample chart with placeholder data. It will be selected (with a blue border).
Edit the data. Click the Linked options icon (a small chain-link or arrow) at the top-right of the chart, then select Open source. This opens a linked Google Sheets spreadsheet with the sample data.
Replace the sample data in the spreadsheet with your own. For example, in column A put your category names (e.g., “Q1”, “Q2”, “Q3”), and in column B put the values (e.g., “10”, “15”, “7”). You can also edit the series name in row 1 (e.g., “Sales”).
Close the spreadsheet. After editing, you can close the Sheets tab. The chart in Docs will update automatically after a few seconds. If it doesn’t, click the Refresh icon (circular arrow) on the chart.
Customize the chart’s appearance. Click the chart to select it, then click the Edit chart icon (pencil) in the top-right corner. A sidebar opens with tabs: Setup, Customize, and Chart style. Use these to change colors, add a title, adjust axis labels, and more.
Make the chart independent (optional). If you don’t want the chart to stay linked to the spreadsheet, click the Linked options icon and select Unlink. The chart becomes a static image that you can still edit, but changes won’t sync with Sheets.
Resize and position. Drag the corner handles to resize the chart. To move it, click and drag it to a new location. Use the alignment options in the toolbar to center it or wrap text around it.

Common Mistakes

Not editing the data source: Some users try to click directly on the chart’s bars and type, but that doesn’t work. You must open the linked spreadsheet to change the data.
Choosing the wrong chart type: For example, using a pie chart for data that changes over time (use a line chart instead) or using a bar chart for a single category (use a column chart).
Forgetting to update after editing: After you edit the spreadsheet, the chart may not refresh immediately. Click the refresh button to force an update.
Unlinking too early: If you unlink the chart before you’re done editing, you lose the ability to sync changes from Sheets. Only unlink when the chart is final.

Tips

Use “From Sheets” for complex data: If you already have a chart in Google Sheets, you can insert it directly via Insert > Chart > From Sheets. This keeps the chart linked to your existing data.
Label your axes clearly: In the Customize tab, add axis titles so readers understand what the numbers represent.
Keep it simple: Too many data series or categories can clutter the chart. Aim for a clean, readable visual.
Use keyboard shortcuts: After selecting the chart, press Ctrl+C (or Cmd+C on Mac) to copy, then Ctrl+V to paste elsewhere in the document.

Troubleshooting

The chart doesn’t update after I edit the spreadsheet. Wait a few seconds. If it still doesn’t change, click the chart and then click the Refresh icon (circular arrow) at the top-right of the chart. If that fails, close and reopen the document.

I can’t find the “Open source” option. Make sure the chart is selected (click on it). The Linked options icon appears in the top-right corner of the chart. It looks like a small chain link or a drop-down arrow. If you don’t see it, try clicking directly on the chart’s border.

The chart looks blurry or stretched. This usually happens after resizing. Hold Shift while dragging a corner handle to maintain the aspect ratio. Also, avoid enlarging the chart beyond its original size too much; instead, consider regenerating it with higher resolution.

I accidentally unlinked the chart and now I can’t edit the data. You can still edit the chart’s appearance (colors, labels) via the Edit chart sidebar, but you cannot change the underlying data. You’ll need to delete the chart and insert a new one, then re-enter your data.

Frequently Asked Questions

Can I create a graph directly in Google Docs without using Google Sheets?

No, Google Docs uses Google Sheets as the underlying data engine for charts. When you insert a chart, it automatically creates a linked spreadsheet. You can unlink it later to make it standalone, but the initial creation requires Sheets.

How do I change the chart type after inserting it?

Click the chart, then click the Edit chart icon (pencil). In the sidebar, go to the Setup tab and choose a different chart type from the “Chart type” drop-down. The chart will update instantly.

Can I add a chart from an existing Google Sheets file?

Yes. Go to Insert > Chart > From Sheets, then select the spreadsheet and the chart you want. It will be inserted as a linked chart.

Why is my pie chart showing percentages that don’t add up to 100%?

This usually happens when your data includes negative values or zero values. Pie charts are best for positive values that represent parts of a whole. Check your data and remove any non-positive values, or consider using a different chart type.

How do I make the chart editable by others?

By default, anyone with edit access to your Google Doc can click the chart and edit it. If you’ve unlinked it, they can only edit the appearance, not the data. To allow data editing, keep the chart linked.

Can I export the chart as an image?

Yes, click the chart to select it, then right-click and choose Copy. Then paste it into a drawing tool or document. Alternatively, you can take a screenshot. For a higher-quality image, open the linked spreadsheet, right-click the chart there, and choose Download as a PNG or PDF.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.