How to Make a Chart in Google Sheets (Step by Step)

Google Sheets makes chart creation pretty fast once you know where everything lives. The menus are slightly different from Excel, the customization panel works differently, and there are a few tricks that’ll save you a lot of time.

Here’s the full walkthrough.

Step 1 — Set Up Your Data

Charts in Google Sheets work best when your data is clean and structured. The golden rule: one header row, data below it, no blank rows in the middle.

If your data has merged cells, extra blank columns, or totals mixed in with your regular rows, clean that up first. A few minutes of data cleanup now saves a lot of chart frustration later.

Step 2 — Select Your Data Range

Click the top-left cell of your data and drag to the bottom-right. Include your header row — Sheets uses those for axis labels and the legend automatically.

If you only want to chart specific columns (not all of them), hold Ctrl (or Cmd on Mac) and click each column header to select non-adjacent columns.

Step 3 — Insert the Chart

Go to Insert in the top menu → click Chart.

Google Sheets will immediately insert a chart and open the Chart Editor panel on the right side of the screen. It makes a best guess at the right chart type based on your data.

If the guess is wrong (it sometimes is), don’t worry — you’ll change it in the next step.

Step 4 — Choose Your Chart Type

In the Chart Editor panel, the first dropdown under “Chart type” lets you switch between chart styles. The most commonly used ones:

Bar chart — comparing categories horizontally
Column chart — comparing categories vertically
Line chart — tracking something over time
Pie chart — showing parts of a whole (keep it to 5 slices or fewer)
Scatter chart — finding relationships between two numbers

Pick the one that fits your data. The preview updates live so you can try a few before committing.

Step 5 — Check the Data Range

Still in the Chart Editor, look at the Data tab. You’ll see the data range it’s pulling from. If rows and columns are switched (your months are showing as series instead of the x-axis, for example), click Switch rows/columns to flip it.

You can also add or remove data series here without going back to your spreadsheet.

Step 6 — Customize It

Click the Customize tab in the Chart Editor. This is where you control the look:

Chart & axis titles — always add a descriptive title. Click “Chart title” and type something meaningful.

Series — change the color of each data series here. Click the colored square next to a series name and pick your color.

Legend — if you only have one data series, turn the legend off. It’s just noise. Uncheck “Legend” or set position to “None.”

Gridlines and ticks — under the Horizontal or Vertical axis sections, you can reduce the number of gridlines if the chart feels cluttered.

Step 7 — Move It Out of the Way

By default, the chart lands on top of your data. Click and drag it somewhere else, or drag the corners to resize it.

For a cleaner setup, right-click the chart → Move to own sheet. This puts the chart on its own dedicated tab, which is much nicer for presentations or sharing.

As an image: Click the three dots (⋮) in the top-right corner of the chart → Download → PNG or PDF.

In a Google Slides presentation: Copy the chart (Ctrl+C), open your Slides deck, paste (Ctrl+V). Google will ask if you want to link the chart — say yes, and it’ll update automatically when the Sheets data changes.

As a link: Share the whole Google Sheet as view-only (Share → Anyone with the link → Viewer). Viewers see the chart but can’t edit anything.

The Most Common Mistakes

Selecting too many columns. If your data has 10 columns and you only want to chart 2, select only those 2. Otherwise Sheets tries to plot everything and the chart becomes unreadable.

Forgetting to include headers. Headers become your axis labels and legend text. Always include the top row in your selection.

Using a line chart for non-time data. Line charts imply a sequence. If your categories are “Product A, Product B, Product C” — not dates — use a column chart instead.

When You Need More Than a Chart

Charts are great for understanding your data. But if you’re trying to build a full dashboard — multiple metrics, shareable with your team, always up to date — you’ll eventually hit the ceiling of what Google Sheets can do cleanly.

Sheetglow connects directly to your Google Sheet and generates a polished dashboard automatically. Your data stays in Sheets. The dashboard lives on its own, updates itself, and actually looks like something you’d want to share.

Google Sheets charts are fast to make and surprisingly flexible. Once you know the steps, the whole process takes under five minutes.