How to Make a Graph in Google Sheets (2026 Guide)
To make a graph in Google Sheets, select your data, go to Insert > Chart, then pick the chart type that fits in the Chart editor. Sheets builds the graph for you and updates it automatically when the underlying data changes. Here is the full process, from choosing the right chart type to giving it its own sheet.
1. Select Your Data
Highlight the cells you want to chart, and include the labels so the graph is readable.
- Click the top-left cell of your data, for example A1.
- Drag to the bottom-right cell, for example B12.
- Include the header row (like “Month” and “Sales”) so Sheets can label the axes and legend.
To chart non-adjacent columns, select the first range, then hold Ctrl (Windows) or Cmd (Mac) and select the others.
2. Insert the Chart
- With the data selected, go to Insert > Chart.
- Sheets drops a chart onto the sheet and opens the Chart editor panel on the right.
- It picks a default chart type based on the shape of your data, which you can change in the next step.
You can drag the chart anywhere on the sheet, and resize it by dragging its corner handles.
3. Choose the Right Chart Type
In the Chart editor, under the Setup tab, open the Chart type dropdown. The common choices:
- Column chart: compare values across categories (sales by month). The default for most tables.
- Bar chart: same as column but horizontal, good for long category names.
- Line chart: show a trend over time (daily visitors).
- Pie chart: show parts of a whole (budget split by category). Best with a handful of slices.
- Scatter chart: plot two numeric variables to spot a relationship.
- Combo chart: mix columns and a line, for example revenue bars with a profit-margin line.
- Area, histogram, and others sit further down the list for specialized cases.
Pick the type that matches the question your data answers. If a chart looks wrong, it is usually the chart type, not the data.
4. Customize the Chart
Switch to the Customize tab in the Chart editor to make the graph clear and on-brand. The sections you will use most:
- Chart style: background color, font, and border.
- Chart & axis titles: type a descriptive title and label both axes. Select Chart title in the dropdown, then enter the text.
- Series: change bar/line colors, add data labels (the numbers on top of each bar), and set point styles.
- Legend: move it to the top, bottom, left, right, or hide it.
- Horizontal axis / Vertical axis: set the number format, min and max values, and tick spacing.
- Gridlines and ticks: add or remove gridlines for a cleaner look.
Every change previews live on the chart, so you can experiment freely.
5. Edit a Chart Later
To reopen the editor after closing it:
- Click the chart once to select it.
- Click the three-dot menu in its top-right corner.
- Choose Edit chart.
The same menu also has Delete chart, Download (as PNG, PDF, or SVG), and Copy chart so you can paste it into Google Docs or Slides, where it can stay linked to the live data.
6. Move the Chart to Its Own Sheet
For presentations or dashboards, a full-page chart often reads better than one floating over the data.
- Click the chart to select it.
- Click the three-dot menu in the top-right corner.
- Choose Move to own sheet.
Sheets creates a new tab (named “Chart 1” by default) holding only the chart, sized to the page. To bring it back, open that chart’s three-dot menu and choose Move to [your data sheet].
Charts Update Themselves
A key advantage of building charts in Sheets: they are linked to the data range. When you edit, add, or remove values in the source cells, the chart redraws automatically. If you add new rows below your data, open Edit chart, go to Setup, and extend the Data range to include them.
Quick Reference
| Goal | Chart type |
|---|---|
| Compare categories | Column or Bar |
| Trend over time | Line |
| Parts of a whole | Pie |
| Relationship between two numbers | Scatter |
| Two metrics together | Combo |
Let Carly Keep Your Dashboards Current
A chart is only as fresh as the data behind it, and keeping that data current is the tedious part. Carly is an AI assistant that connects to 200+ apps including Google Sheets and handles the repetitive follow-through, logging new numbers into the source range so your charts redraw on their own, and pulling the latest figures into a recurring report or email. You design the graph once, Carly feeds it. Carly starts at $35/month.
More on Google Sheets: How to create a pivot table in Google Sheets · How to use the QUERY function in Google Sheets · How to use conditional formatting in Google Sheets · Google Sheets integration
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."