Google Sheets Graphs: Create and Customize One

To make a graph in Google Sheets, select the cells containing your data, choose Insert > Chart, then use the Chart editor to pick a chart type and adjust its labels or appearance. Sheets calls these visualizations charts, but the same steps create the kind of graph most people mean: a visual comparison of values, changes over time, or relationships between numbers.

Prepare your data before making a chart

A chart is only as clear as the table behind it. Put each category or date in one column and the measurements you want to compare in adjacent columns. Give each column a descriptive heading, and keep each row consistent: one row per month, product, person, or other category. For example, a monthly sales table might have Month in column A, North in column B, and South in column C, with one month per row.

Use real dates or numbers when the data represents dates or numbers. Typing a month name as text can be fine for a category axis, but actual date values are often more useful for time-based charts. Avoid merged cells, blank separator rows, and extra notes inside the selected data range. These can make Sheets interpret the table incorrectly. If a number has been entered as text, Sheets may omit it from a numeric series or treat it unexpectedly.

Put headers in the first row of the range, such as Month and Sales.
Keep category labels in the first column and values in the neighboring columns.
Use a consistent unit, such as dollars or units sold, within each series.
Include only the table you want charted; leave footnotes and unrelated totals outside the range.

You do not need to format the table with colors or borders first. Clear headings and consistent values matter more to chart setup than decorative cell formatting.

Create a chart in Google Sheets

Open the spreadsheet in Google Sheets in a web browser and follow these steps:

Select the cells to chart, including the column headings and the category labels. For example, if the headings are in row 1 and data is in rows 2 through 13, select A1:C13.
Choose Insert > Chart from the menu. Sheets inserts a chart into the sheet and opens the Chart editor, usually at the right.
In the editor’s Setup tab, check the Chart type setting. Sheets chooses a chart automatically, but you can open the menu and select a different type.
Check the Data range, X-axis, and Series settings. Confirm that the intended labels and value columns are included.
If the chart has interpreted rows and columns incorrectly, use Switch rows/columns. Check or uncheck Use row 1 as headers and Use column A as labels as appropriate for your table.
Close the Chart editor when the chart looks right. You can reopen it later by double-clicking the chart or using its three-dot menu and choosing Edit chart.

The chart is an object placed over the sheet, rather than a replacement for the underlying cells. Drag it to move it, or drag a corner or side handle to resize it. The source data remains in the cells and can still be edited normally.

Choose the right chart type

The best chart type depends on what you want a reader to notice. A column chart is a strong starting point for comparing a few categories, such as sales by region. A bar chart uses horizontal bars and can be easier to read when category names are long. A line chart is generally useful for showing how a value changes across an ordered sequence, especially dates.

Other chart types answer different questions:

Pie or doughnut: Shows how a small number of categories make up a whole. Use it when the categories are parts of one total and the slices are easy to distinguish.
Scatter: Plots paired numeric values to show whether two measurements appear related. It is different from a line chart because the horizontal axis represents numeric values rather than simply a sequence of categories.
Area: Emphasizes the size of values or totals over a sequence, though overlapping filled areas can become hard to interpret.
Combo: Combines chart styles, such as columns and a line, when two series need different visual emphasis. Use it sparingly and label each series clearly.

For example, to compare North and South monthly sales, a line chart can show the trend for both regions; a column chart can make the month-by-month comparison more prominent. A pie chart would usually be a poor fit because the months are not parts of a single whole. Avoid choosing a type solely because it looks distinctive: the chart should make the intended comparison easier to understand.

Customize titles, labels, and appearance

To change the chart’s presentation, open the Chart editor and select Customize. The options shown depend on the chart type. Chart style controls general appearance, while Chart & axis titles lets you enter a chart title, subtitle, and titles for available axes. Prefer a title that says what is being measured and, where useful, the period or unit. For example, Monthly Sales by Region, 2025 is more informative than Sales.

Use the Series section to adjust the look of individual data series and, where supported, add features such as data labels. The Legend section controls whether a legend appears and where it is placed. Axis settings and Gridlines and ticks can help make values easier to estimate. Options are contextual: a pie chart does not have the same axes as a line chart, so its editor will not show every axis control.

Keep customization purposeful. Use distinct colors for series that readers need to compare, make text readable at the chart’s displayed size, and avoid excessive gridlines or labels. If exact values matter, data labels can help, but labeling every point in a crowded chart may make it less legible. You can change the chart’s size on the sheet to give long labels more room, too.

Edit the data range and understand updates

You can change what a chart uses without deleting and rebuilding it. Open Edit chart, then in Setup update the Data range or add and remove entries in Series. The X-axis field controls the categories or horizontal values used for the chart. This is useful if you originally selected too many columns, missed a heading, or want to compare a different set of values.

Charts update when their referenced cell values change. However, if the chart uses a fixed range such as A1:C13, typing a new month in row 14 does not necessarily add that row to the chart. Expand the range in Setup to include the new row, or create the chart from a range that already covers the records you expect to use. Check the displayed range rather than assuming that every new row will be included automatically.

If you change the table layout, revisit the Setup tab. A chart may continue to reference the old cells even if the data has moved, and added columns may not be included. Keeping the source table in a simple, continuous block makes future edits easier to manage.

Fix common chart problems

If the chart is blank, first confirm that the selected range contains values and that the values are numeric where a numeric series is expected. Check for numbers stored as text, an incorrect data range, or a header accidentally used as a data point. If the chart shows a separate series for every row when you expected one series per column, try Switch rows/columns and review the header and label checkboxes.

If the horizontal axis shows numbers instead of names, check that the category-label column is included and that Use column A as labels is set correctly for your layout. If the legend contains generic names such as Series 1, include the header cells or adjust the series names in Setup. When dates appear in an unexpected order, check that they are actual date values and inspect the X-axis selection.

A chart can also be technically correct but difficult to read. Too many series, long category labels, or a scale that hides meaningful differences can obscure the message. Reduce the number of displayed categories, choose a more suitable chart type, enlarge the chart, or revise the axis and labels. For a misleading impression, check the vertical-axis scale: a truncated scale can make small differences look dramatic. Use a scale that communicates the comparison fairly and clearly.

Move, copy, and share a chart

To reposition a chart, drag it within the sheet; to adjust its dimensions, drag its resize handles. For a chart that needs a separate workspace, open the chart’s three-dot menu and choose Move to own sheet, if that option is available in the chart menu. This places the chart on a dedicated sheet tab while leaving the source data in the spreadsheet.

You can copy a chart and paste it into another Google app, such as Google Docs or Slides, when you need it in a report or presentation. The paste flow may offer a linked chart option; a linked chart can be updated from its source spreadsheet, while an unlinked copy will not reflect later source changes. Review the prompt and choose the behavior that fits your document. Sharing the spreadsheet itself is controlled by its Google Drive sharing settings, so check who has access before sending a link.

Google Sheets is available through a Google account, and core chart creation does not require buying a separate charting application. Access to a work or school account, storage, or additional Google Workspace services may depend on the organization’s plan. In Excel, charts are made through its own interface—commonly Insert > Recommended Charts or Insert > a chart type—so Google Sheets menu instructions do not map one-for-one to Excel.

Frequently Asked Questions

How do I make a graph in Google Sheets on my phone?
In the Google Sheets mobile app, select the relevant cells, tap the plus button, and choose Chart. Review the chart type and available settings in the mobile editor. The exact controls can vary by device and app version; for more detailed setup, the web browser version offers the Chart editor with Setup and Customize tabs.

How do I add a title to a Google Sheets graph?
Open the chart editor, select Customize, then open Chart & axis titles. Choose the title type you want and enter the text. You can also add a subtitle or an axis title when that option is available for the chart type.

Why is my Google Sheets chart showing the wrong data?
Open Edit chart and check the Data range, X-axis, and Series in the Setup tab. Confirm that the header and category-label settings match your table. If the data is arranged in rows instead of columns, try Switch rows/columns.

How do I make a line graph in Google Sheets?
Select the data range, including headings and labels, then choose Insert > Chart. In the Chart editor’s Setup tab, open Chart type and select a line chart. Verify that the horizontal axis contains the date or category sequence and that each intended value column appears as a series.

Will a Google Sheets graph update when I change the data?
Yes, changes to cells already included in the chart’s data range are reflected in the chart. New rows outside a fixed range may not be included automatically, so update the range in Setup when you add data beyond its current boundary.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.