Google Sheets Chart Tutorial: Create and Customize Charts

To create a chart 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 setup or appearance. The steps below explain how to prepare data, choose a useful chart, format it, and fix common problems in Google Sheets in a web browser.

What a Google Sheets chart does

A chart turns spreadsheet values into a visual summary. Instead of scanning rows of figures, readers can compare categories, notice changes over time, or see how two numerical measures relate. Google Sheets creates charts from cell ranges in a spreadsheet, and the chart remains connected to its source data. When values in the selected range change, the chart generally updates to reflect them.

Charts are useful for reports, project tracking, classroom assignments, and shared dashboards. They do not replace the underlying table: the table holds exact values and details, while the chart emphasizes patterns. A well-chosen chart makes a specific point quickly; a crowded or poorly labeled one can make accurate data difficult to interpret.

In a browser, the main workflow is Insert > Chart, followed by options in the Chart editor. Google Sheets may suggest a chart type automatically, but that suggestion is only a starting point. Check that the categories, series, and labels match what you intend to communicate.

Prepare the data before charting

Good chart setup begins with a clean, rectangular data range. Put descriptive headings in the first row, and use the first column for category labels when appropriate. Each remaining column should contain one series of values. For example, a small quarterly sales table might have Quarter, North region, and South region as its headings, with Q1 through Q4 in the first column and numeric sales in the other two.

Before selecting the range, check the following:

Keep each column consistent: do not mix dates, explanatory notes, and numbers in one series.
Use a clear heading for every series, such as Expenses or Sign-ups, rather than leaving headings blank.
Make sure values intended to be numbers are recognized as numbers. Text-formatted numbers may not plot as expected.
Use one row per observation and avoid merged cells inside the data range, since they can confuse the chart’s interpretation of rows and columns.
Include only the data needed for the chart. Selecting unrelated notes or totals can add misleading categories or series.

Dates work best when Sheets recognizes them as dates rather than plain text. If a chart’s horizontal axis should show time, arrange the dates in order and use a consistent interval where possible. A total row may be useful in the worksheet but often should be excluded from a chart of individual periods; otherwise, the total appears as another period and can distort the comparison.

Create a chart step by step

Open the spreadsheet in Google Sheets in a web browser and select the cells you want to chart, including headings and category labels.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually on the right side of the window.
In the editor’s Setup tab, check the Data range. Correct it if Sheets selected too many or too few cells.
Choose a chart from the Chart type menu. The suggested chart may be suitable, but select another type if it does not fit your data or purpose.
Review the X-axis and Series settings. The X-axis should usually contain labels such as months or product names; the series should contain the values you want to compare.
Check whether Use row 1 as headers and Use column A as labels are set appropriately for your table. If the chart has series and categories reversed, try Switch rows/columns.
Use the Customize tab to add titles and adjust the legend, colors, axes, and other available options.

You can reposition the chart by dragging it within the sheet and resize it using its handles. To keep a chart separate from the grid, open the chart’s three-dot menu and choose Move to own sheet. This is useful for a presentation-style chart page, though the data still lives in the spreadsheet.

Choose the right chart type

Match the chart to the question, not just to the shape of the data. The best chart is usually the simplest one that makes the comparison clear.

Line chart: Useful for showing a trend across ordered values, especially dates. A line chart can make changes over time easier to see than a table.
Column chart: Shows vertical bars and works well for comparing a modest number of categories or series. Use it for quarterly sales by region, for example.
Bar chart: Uses horizontal bars, which can be easier to read when category names are long or there are many categories.
Pie chart: Shows how categories contribute to a whole. It is clearest with a small number of categories that add up to a meaningful total; many similar-sized slices are hard to compare.
Scatter chart: Plots paired numerical values to show whether two measures vary together. For instance, it might compare advertising spend with website visits for several campaigns.
Combo chart: Combines chart styles, such as columns and a line, when two series need different visual treatment. Use it carefully and label each measure clearly.

A histogram is designed to show the distribution of numerical values by grouping them into ranges, rather than comparing named categories. For example, it can show how many delivery times fall into each interval. For a trend with many dates, a line chart is usually more informative than a pie chart; for a few distinct product totals, bars or columns are often easier to compare.

Customize titles, labels, and appearance

Select the chart to reopen its Chart editor, then use Customize. Available controls vary with the chart type, so a setting shown for one kind of chart may not appear for another. Start with meaning and readability: the title should state what is being measured, and axis titles should clarify units when they are not obvious.

In Chart & axis titles, enter a chart title or choose a title type such as a horizontal-axis or vertical-axis title. In Legend, change the legend’s position or formatting. Under Series, options can include changing a series color and, for supported chart types, displaying data labels. Labels are useful when readers need exact values, but putting a number on every point can clutter a chart with many observations.

Use axis controls and gridlines to make scales easy to understand. If the vertical axis starts above zero, say so clearly when that choice could exaggerate a difference. Avoid using many strong colors for series that are not important to distinguish, and make sure the chart remains understandable when printed or viewed by people who may not distinguish colors easily. A chart should not depend on color alone if labels or patterns can clarify the data.

Formatting should support the message rather than decorate it. For example, a chart of monthly website visits can use a title such as Monthly visits, a horizontal axis labeled Month, and a vertical axis labeled Visits. If the units are dollars, include that context in a title or axis label so the values are not mistaken for counts.

Update, move, and share a chart

A chart is linked to the spreadsheet cells used for its data range. Editing values in those cells updates the visual, but adding new rows outside the selected range may require you to edit the range in Setup. Select the chart, open the Chart editor, and check Data range if recently added records do not appear. If a chart is meant to cover a growing list, periodically confirm that its range includes the new rows.

Charts can be copied, moved, or placed on their own sheet. When sharing a spreadsheet, the chart and its source data follow the spreadsheet’s sharing permissions: a recipient’s ability to view or edit depends on the access granted to the file. If you share a chart as part of a report, verify that the recipient can access the underlying spreadsheet when they need to inspect the data. A chart image pasted elsewhere may not behave like the editable chart in the sheet.

Common chart problems and fixes

The chart shows the wrong categories: In Setup, inspect the X-axis range and whether the first column is being used as labels. Check Switch rows/columns if rows and columns have been interpreted in reverse.
Numbers appear as labels or do not plot: Check that the source cells contain numeric values rather than numbers stored as text. Also confirm that the correct cells are included in the Data range.
The chart includes a heading or total as a data point: Adjust the selected range and review the header and label options. Exclude summary rows if they are not observations comparable with the other rows.
New data is missing: The chart may still point to its original range. Expand Data range in Setup to cover the added cells.
The chart is hard to read: Reduce the number of series or categories, use a more suitable chart type, and add clearer titles. A long list of category names may work better as a bar chart than as vertical columns.
There is an unexpected blank category: Look for empty cells within the selected range or stray formatting and data beyond the intended table. Tighten the range if necessary.

When troubleshooting, make one change at a time. First verify the source range and labels, then change the chart type or formatting. This helps distinguish a data problem from a design choice.

Google Sheets charts compared with Excel

Google Sheets and Microsoft Excel both create charts from selected worksheet data, and many familiar chart types are available in both. The interfaces differ: this tutorial uses the Sheets browser menus and its Chart editor, while Excel for Microsoft 365 uses the ribbon, including Insert chart options and chart-specific tabs. Menu names and some formatting controls are not identical, so instructions for one program should not be assumed to work in the other.

Sheets is useful when people need to collaborate in a shared online spreadsheet, while Excel may suit workflows built around Microsoft 365 files and its broader desktop features. In either program, the basic principles are the same: prepare a clear data table, select a fitting chart, label it, and verify that the plotted range tells the intended story.

Frequently Asked Questions

How do I make a chart in Google Sheets?
Select the data, including its headings, and choose Insert > Chart. Review the chart type, data range, X-axis, and series in the Chart editor, then use Customize to format the chart.

How do I change a chart type in Google Sheets?
Select the chart and open the Chart editor. In the Setup tab, choose a different option from the Chart type menu. Check the axes and series afterward because different chart types may interpret the data differently.

How do I add data labels to a Google Sheets chart?
Select the chart, open Customize, and look under Series for the Data labels option when it is available for that chart type. Labels may not be available in the same way for every chart, and too many labels can make the display crowded.

Why is my Google Sheets chart not updating?
Changes within the chart’s source range should be reflected in the chart. If new rows are missing, select the chart and check or expand Data range in the Setup tab of the Chart editor.

Can I put a Google Sheets chart on its own page?
Yes. Open the chart’s three-dot menu and choose Move to own sheet. The chart is displayed separately from the worksheet grid, while its data remains in the spreadsheet.

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.