How to Make a Graph in Google Sheets: A Step-by-Step Guide

To make a graph in Google Sheets, arrange your information in a table with headings, select the cells you want to plot, then choose Insert > Chart. Use the Chart editor to pick a chart type and adjust its labels, titles, and appearance. The steps below are for Google Sheets in a web browser; Excel has different menus, even though the overall process is similar.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
A small, organized data table. Include a heading for each column, such as Month and Visitors, and keep each row to one observation.
A clear idea of what you want to compare or show over time. This helps you choose a chart that makes the pattern easy to read.

Step-by-Step

Organize and check your data. Put categories in one column and the values you want to graph in the next. For example, enter Month in A1 and Visitors in B1, then list January, February, and March in A2:A4 and their visitor counts in B2:B4. Keep the headings in the first row, avoid blank rows inside the table, and make sure the values are numbers rather than text. Dates should be entered as dates, not as labels that only look like dates. A tidy table helps Sheets identify the chart labels and data series correctly.
Select the range to graph. Click the first cell and drag across the headings and all the data, such as A1:B4 in the example. Include the headings so Sheets can use them for the chart legend or axis labels. If your table has more than one value column, include all the columns you want to compare. Check that you have not selected unrelated notes or totals nearby; extra cells can create an unwanted series or distort the chart.
Insert a chart. With the range selected, choose Insert > Chart from the top menu. Google Sheets adds a chart to the sheet and opens the Chart editor, usually on the right. Sheets chooses a chart type automatically, but the first result is only a suggestion. If no chart appears, or the editor is hidden, check that the data range is still selected and look for the Chart editor panel at the right side of the window.
Choose a chart type that fits the data. In the Chart editor, open the Setup tab and select the Chart type menu. A column chart works well for comparing values across a short list of categories. A bar chart is useful when category names are long. A line chart is often clearer for values measured over time, such as monthly visitors. A pie chart can show how a few parts contribute to one whole, but it becomes hard to interpret with many categories. For two numeric variables, a scatter chart can show whether the values move together. Use the type that answers your question, rather than choosing one only for decoration.
Confirm the data range and series. In Setup, review the Data range field and the X-axis and Series sections. The data range should cover the cells you intend to chart, including headings. In the example, the month names should be the horizontal-axis labels and Visitors should be the plotted series. If Sheets assigns the months as a series instead, use the row and column controls in Setup to switch how it interprets the data. Check the options for using row 1 as headers and column A as labels when they are available; they help Sheets read the table correctly.
Add a useful title and labels. Open Customize in the Chart editor, then expand Chart & axis titles. Choose the title type you want to edit, such as Chart title, Horizontal axis title, or Vertical axis title, and enter concise wording. For example, a title like Monthly Website Visitors tells a reader what the graph represents. If the vertical axis needs units, include them in its title, such as Visitors or Revenue in dollars. Keep labels short enough to fit, and avoid relying on color alone to explain what each series means.
Adjust the legend and visual details. In Customize, open Legend to change its position or remove it if there is only one series and it adds clutter. Use Series to adjust the appearance of a data series, or Gridlines and ticks to change how the axes are displayed. The available controls vary with the chart type. Make changes gradually and check whether the values remain easy to compare. For instance, a line chart with two series usually needs a visible legend, while a single-series chart may be clearer without one.
Position the chart and check the result. Click the chart and drag it to a clear area of the sheet; use its corner handles to resize it. Check that the labels are readable, the scale does not hide meaningful differences, and no rows or categories are missing. To change the chart later, click it and use the three-dot menu or the Chart editor controls. If you edit values in the cells covered by the chart’s data range, the chart will normally update. If you add more rows later, check the range to confirm those rows are included.

Common Mistakes

Leaving out the headings: Selecting only numbers can leave the chart with generic series names or unclear categories. Include the header row and confirm that Sheets recognizes it as headers. Mixing labels and values: Text such as “about 50” in a value cell may be treated as text rather than a number. Store the number separately and put explanations in another column or a note. Choosing an unsuitable chart: A pie chart with many similar slices is difficult to compare, and a line chart can imply a continuous sequence where none exists. Match the chart type to the question. Including totals with their parts: Adding a total row to the plotted data can make the other values look misleading, especially in a pie chart. Exclude totals unless they are genuinely a separate category you want to display.

Tips

Write the question you want the chart to answer before choosing a type: for example, Which month had the most visitors? or How did attendance change through the year?
Use consistent units and time intervals. Comparing weekly figures with monthly figures in one series can create a confusing picture.
Keep the chart simple. A clear title, readable labels, and a small number of series are usually more useful than lots of colors or effects.
For data that changes often, make sure the chart’s data range includes the rows where future entries will go. You can review or edit the range in the Setup tab.
If you share the spreadsheet, make sure the intended readers have access to it. A chart in a Sheet is connected to its source data, so edits to the data can affect what viewers see.

Troubleshooting

The chart is blank or has no useful bars or lines: Check that the selected range includes numeric values and that the values are not stored as text. Click a value cell and check its contents; remove stray spaces or symbols that were typed into the cell, then format the cell appropriately if needed. Recheck the Data range in Setup as well.

The chart uses the wrong labels: In Setup, inspect the X-axis and Series assignments. Confirm that the category column is used for the X-axis and the numeric column is a series. Check the header and label options, or use the row/column switch if the data is arranged in the opposite direction from what Sheets expected.

Some rows or categories are missing: Review the Data range field and expand the range to cover the cells you intended to include. Look for blank rows or columns that may split the table, and check whether filters or hidden rows affect what you are viewing. If new data was added after the chart was made, verify that the chart range extends to those new rows.

The chart looks crowded or hard to read: Try a bar chart for long category names, shorten labels in the source table, or remove unnecessary series. If the scale makes small changes difficult to see, review the vertical-axis settings in Customize. Avoid changing the scale merely to exaggerate a difference; choose a range that presents the values fairly.

The Chart editor is missing: Click the chart and use its three-dot menu to open the editing controls, or double-click the chart. If you are on a narrow browser window, the panel may be difficult to see; widen the window or zoom out in the browser. In Sheets, the equivalent of Excel’s chart-insertion workflow is Insert > Chart, but the Chart editor tabs and options described here are specific to Google Sheets.

Frequently Asked Questions

Is a graph different from a chart in Google Sheets?
People often use the terms interchangeably. Google Sheets calls the feature a chart, and Insert > Chart is the menu command used to create a graph from spreadsheet data.

Can I change the chart type after creating it?
Yes. Select or double-click the chart, open the Chart editor’s Setup tab, and choose another option from Chart type. Check the labels and series afterward, because a different type may display the same data differently.

How do I make a graph with two data series?
Place each series in its own column, with a heading at the top and matching category labels down the first column. Select the full table, including headings, and insert a chart. In Setup, confirm both value columns appear under Series and the category column is used for the X-axis.

Will a chart update when I change the spreadsheet data?
It normally updates when you change cells within its data range. If you add rows outside that range, the chart may not include them automatically. Open Setup, review Data range, and extend it to cover the new entries.

Can I create a chart from non-adjacent columns?
Yes, but selecting separate ranges can take more care than selecting one continuous table. After inserting the chart, review the Data range, X-axis, and Series settings in Setup and correct any cells Sheets included or missed. When possible, arranging the needed columns together in a clean table makes the chart easier to maintain.

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.