How to Make a Graph in Google Sheets
To make a graph in Google Sheets, select your data, click Insert > Chart, and pick a chart type in the Chart editor. Here is how to build it, choose the right type, and customize it — step by step.
A graph makes numbers easy to understand at a glance, and Google Sheets builds one for you automatically from whatever data you select. Here is the fastest way to create one, plus how to pick a chart type that actually fits your data.
How to insert a graph in Google Sheets
- Select the data you want to graph, including the row and column headers.
- Click Insert in the menu, then Chart.
- Google Sheets adds a chart and opens the Chart editor on the right, with a suggested type.
- In the Chart editor, use the Chart type menu to choose the graph you want (column, line, pie, and so on).
- Drag the chart to reposition it, or drag a corner to resize.
Choosing the right graph type
The type matters more than the colors. Match it to the story your data tells:
| Graph type | Best for |
|---|---|
| Column or Bar | Comparing values across categories (sales by product) |
| Line | Showing a trend over time (revenue by month) |
| Pie | Parts of a whole, with only a few slices (budget split) |
| Scatter | The relationship between two numbers (price vs. sales) |
Customize your graph
Double-click any part of the chart to reopen the Chart editor, then switch to the Customize tab. There you can:
- Add or edit the chart title and axis titles.
- Turn on data labels so the exact numbers show on the chart.
- Change colors, fonts, and the legend position.
Give the chart a title that states the takeaway ("Sales grew 20% in Q4"), not just the data name — that is what makes it useful to someone who did not build it.
Graph from a summary, not raw data
Graphs look best on top of a clean summary rather than hundreds of raw rows. The easiest way to build that summary is a pivot table in Google Sheets, which groups and totals your data for you. Working in Excel instead? See how to make a chart in Excel.
Frequently asked questions
How do I edit a graph after creating it in Google Sheets?
Double-click the chart to reopen the Chart editor on the right. Use the Setup tab to change the type or data range, and the Customize tab to change titles, colors, and labels.
Why is my Google Sheets graph empty or wrong?
Usually the wrong range is selected, or text is mixed in where numbers should be. Double-click the chart, open the Setup tab, and check that the Data range covers your headers and values with no stray text cells.
How do I download a graph from Google Sheets?
Click the chart, then the three-dot menu in its top-right corner, and choose Download. You can save it as a PNG image, PDF, or SVG to use in documents or slides.