Google Sheets Charts and Graphs: How to Create and Choose

Google Sheets charts and graphs turn spreadsheet data into visuals such as column, line, pie, and scatter charts. To create one in a browser, select your data, choose Insert > Chart, then use the Chart editor to choose a chart type and adjust its setup and appearance.

What charts and graphs mean in Google Sheets

In everyday use, “chart” and “graph” often mean the same thing: a visual representation of values in a spreadsheet. Google Sheets calls the feature a chart. The chart is placed on the sheet as an object, while the underlying data remains in cells that you can edit, sort, or update.

A chart can make a pattern easier to spot than a column of numbers. For example, a table of monthly orders may be accurate but hard to scan; a line chart can show whether orders are generally rising, falling, or fluctuating. A chart does not prove why a pattern occurred, though. It presents the data you provide, so the choice of ranges, labels, and scale affects what readers see.

Charts are useful for dashboards, classroom assignments, budgets, project tracking, and reports. They can be simple, such as a bar chart comparing five products, or more specialized, such as a histogram showing how a set of test scores is distributed. The best choice depends on the question the data should answer, not on which chart looks most decorative.

How to create a chart

Start with a tidy data range. Put descriptive headers in the first row, keep each category or date in one column, and place the numeric values in adjacent columns. For example, a table with Month in column A and Orders in column B is easier to chart than a sheet with blank rows, merged cells, and notes mixed into the figures.

Select the cells containing the labels and values you want to visualize. Include the header row when it identifies the series.
Choose Insert > Chart. Sheets inserts a suggested chart and opens the Chart editor, usually at the right side of the browser window.
In the editor’s Setup tab, check the chart type, data range, X-axis, and series. Confirm that the category labels and values have been assigned correctly.
Use the Customize tab to change relevant details such as the chart title, legend, colors, axes, or gridlines.
Click outside the chart editor when you are done. Drag the chart to reposition it, or use its handles to resize it.

Double-clicking a chart opens the editor again. You can also select the chart and use its three-dot menu for available chart actions. The editor’s options depend on the chart type, so a pie chart will not offer every axis setting available for a line chart.

Choosing the right chart type

Choose a chart according to the comparison you want readers to make. A clear chart usually has one main job: compare categories, show change over time, show a relationship, or summarize parts of a whole.

Column or bar chart: Compare values across categories, such as sales by product or sign-ups by region. Bars are especially helpful when category names are long; columns can work well for a modest number of short labels.
Line chart: Show how a measure changes across an ordered sequence, often dates. A line chart can reveal a trend, but connecting unrelated categories with a line may imply continuity that is not present.
Pie chart: Show how categories contribute to one whole, such as the share of total responses by answer. It is easiest to read with a small number of distinct categories and values that make up a meaningful total.
Scatter chart: Compare two numeric measures, such as hours studied and exam scores. Each point represents a pair of values, making this a useful way to look for a relationship or unusual observations.
Histogram: Group numeric observations into intervals to show their distribution. It answers a different question from a bar chart: a histogram groups ranges of numbers, while a typical bar chart compares named categories.
Combo chart: Put different series, such as columns and a line, in one chart when the measures are related and the combined display is readable. If the scales differ substantially, readers may misinterpret the comparison; use a secondary axis only when it genuinely helps.

For example, to compare revenue for five stores, use a bar or column chart. To show total revenue by month across a year, use a line chart. To compare each store’s share of one month’s total, a pie chart may work, but a bar chart is often easier to compare when there are many stores or similar-sized shares.

Prepare data so the chart reads correctly

Chart problems often begin in the source range rather than in the chart itself. Keep one kind of information in each column, use consistent date and number formats, and avoid including totals in a series when those totals would be counted again with the underlying values. A grand-total row, for instance, can create a misleadingly large bar if it is included beside the individual categories.

Headers help Sheets distinguish labels from data. In Setup, review options such as Use row 1 as headers and Use column A as labels when they are available. If the chart treats a row of dates as a data series, or uses numbers as category names, the selected range or header settings may need correction. The Switch rows/columns option can help when the series and categories are oriented the opposite way from what you intended.

Missing values deserve attention too. A blank cell, a zero, and text such as “not recorded” do not necessarily communicate the same thing. Choose a consistent treatment that reflects what the data means. If a category has no recorded value, do not enter zero unless zero is actually the right value; otherwise, the chart may suggest that something was measured and found to be none.

Customize titles, labels, colors, and axes

In the Customize tab, Chart and axis titles let you add a title and, where supported, titles for horizontal and vertical axes. Prefer a specific title such as “Monthly orders, January–June” to a generic one such as “Chart.” Include units when they matter, for example “Revenue (dollars)” or “Distance (kilometers),” so readers do not have to infer the scale.

Legend settings can help identify multiple series. If there is only one series and the categories are already labeled, a legend may take up space without adding information. Use colors consistently and make sure the categories remain distinguishable; do not rely on color alone to convey a critical distinction when labels can clarify it.

Axis settings can change how a chart is perceived. A vertical axis that begins above zero can make small differences between bars look dramatic, while a scale that is much wider than the data can make meaningful changes look nearly flat. There are cases where a nonzero scale is appropriate, particularly for some line charts, but it should be deliberate and clearly understood. Check axis bounds and number formats after changing them, and keep gridlines subtle enough that they support rather than compete with the data.

Keep charts useful as data changes

An embedded chart uses a specified source range. When values in that range change, the chart generally reflects the updated data. However, adding new rows below the range does not guarantee that every chart will include them. Open Setup and inspect the data range if newly entered dates or categories are missing. Using a range that includes planned future rows can help, but check that blank rows do not create confusing labels or empty categories.

For a simple example, suppose a weekly report tracks visits in columns A and B, with Week in A1 and Visits in B1 and data in rows 2 through 9. A chart based on A1:B9 can show those eight weeks. If a ninth week is entered in row 10, inspect the chart’s range to confirm that row 10 is included. This small check prevents a polished chart from quietly becoming out of date.

When the source data is reordered or expanded, review labels and series as well as the chart’s appearance. A chart can remain visually attractive while showing the wrong range. For recurring reports, keep the source table organized and make chart checks part of the update routine.

Common chart problems and fixes

The chart shows the wrong categories: In Setup, verify the X-axis range and whether the first row or first column should be treated as labels.
Numbers appear as labels or labels appear as a series: Check the selected range, header options, and Switch rows/columns. Make sure the cells contain actual numbers or dates rather than text that only looks numeric.
A new row does not appear: Inspect the chart’s data range and extend it to include the added data if needed.
A pie chart looks cluttered: Reduce the number of categories, group small categories only when that grouping is meaningful, or choose a bar chart for easier comparisons.
The chart is hard to read: Shorten the title, clarify units, simplify colors, and review the axis scale. Removing unnecessary series can be more effective than adding formatting.
The chart is blank or incomplete: Confirm that the selected range contains usable values and labels, and look for blanks, text-formatted numbers, or accidental filters that exclude rows.

When diagnosing an unexpected chart, return to the data before changing several design settings at once. Verify the source values, then the selected range and series, and only then adjust formatting. That order makes it easier to identify the actual cause.

Share, copy, and protect chart context

A chart in a Google Sheets file is shared according to the file’s access settings. People who can open the sheet can generally see the chart and its source context, subject to the permissions granted for that file. To share it with someone, use the file’s Share controls and choose access deliberately; a chart can reveal information even if a viewer does not need to edit the spreadsheet.

You can copy a chart from Sheets into Google Docs or Slides. When prompted, you can choose whether to link it to the spreadsheet. A linked chart can be updated from its source when the underlying data or chart changes; an unlinked paste is a static copy. Linked content is useful for reports that are revised regularly, but check the document or slide before sending it so that the displayed version is current.

Google Sheets also provides a Publish to web option through File > Share > Publish to web. Publishing is different from ordinary sharing: depending on the publishing choices and account settings, the published content may be accessible to a wider audience. Do not publish a chart containing confidential or personal information unless you have confirmed that public or broader access is appropriate.

Google Sheets charts compared with alternatives

Google Sheets is convenient when the data already lives in a shared spreadsheet and several people need to update it in a browser. Its chart editor places setup and styling controls alongside the sheet, and charts can be reused in Google Docs and Slides. Google Sheets is not the only option: a chart made in a slide or design tool may offer more layout control, while a dedicated analytics product may suit a larger reporting workflow.

Excel also creates charts from spreadsheet data, but its interface and commands differ. In Excel for Microsoft 365, chart creation is handled from the Insert tab, and chart-specific controls appear on the ribbon; it does not use Google Sheets’ Chart editor with Setup and Customize tabs. The underlying chart principles are similar, but instructions and exact options are not interchangeable between the two programs.

For a chart that needs frequent filtering, exploration, or combination with multiple data sources, consider whether a reporting tool such as Looker Studio fits the task better. For a one-time comparison or a small team’s regularly updated table, Sheets may be simpler. The right alternative depends on data volume, collaboration needs, and the amount of interaction readers need—not on a belief that one charting tool is always superior.

Frequently Asked Questions

How do I make a graph in Google Sheets?
Select the relevant cells, choose Insert > Chart, and check the result in the Chart editor. Use Setup to verify the data range and chart type, then use Customize for titles, legend, axes, and other available appearance settings.

Can Google Sheets make charts automatically?
When you insert a chart, Sheets may suggest a chart type based on the selected data. Treat the suggestion as a starting point: confirm that the category labels, series, and scale answer the question you want the chart to show.

How do I make a chart update when I add data?
Charts update when their source values change, but the chart may not include rows outside its selected data range. Open the chart’s Setup tab and check or expand the range when you add new rows.

Why is Google Sheets making the wrong chart?
The selected range, headers, or row-and-column orientation may be wrong. In Setup, check the data range, X-axis, series, header and label options, and Switch rows/columns. Also confirm that numeric values are stored as numbers.

Can I put a Google Sheets chart in Google Docs?
Yes. Copy the chart and paste it into a Doc. If offered, choose a linked chart when you want the Doc to reference the spreadsheet, or paste it without a link for a static copy; review linked charts for updates before sharing.

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.