Google Sheets: How to Create and Customize a Graph

To create a graph in Google Sheets, select the cells containing your data, including their labels, then choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, where you can choose a chart type and adjust its appearance.

How Google Sheets graphs work

Google Sheets calls a graph a chart, so you will see the word Chart in menus and settings. A chart represents values in selected spreadsheet cells visually. For example, a column chart can compare sales by product, while a line chart can show how a measurement changes over time.

A chart is linked to its source data rather than being a static picture. When you change a value inside the chart’s selected range, the chart generally updates to reflect it. The range matters: if you add new rows beneath the existing data, Sheets may not include them automatically. You can adjust the range in the Chart editor or select a larger range when you create the chart.

In most cases, the first row should contain series names, such as “Revenue” or “Visitors,” and the first column should contain category labels, such as dates or product names. Including these headings helps Sheets interpret the data and gives the chart a useful legend and axis labels.

Prepare the data before making a chart

Clean, consistently arranged data makes chart creation easier and reduces misleading results. Put each variable in its own column, keep one record or time period per row, and avoid inserting blank rows or columns inside the data. A simple monthly sales table might have Month in column A and Sales in column B, with the month names in A2:A13 and numeric sales values in B2:B13.

Before selecting the range, check that:

The headings are descriptive and appear in the first row of the selected range.
Values that should be numbers are actually stored as numbers, not as text. A number stored as text may be ignored or plotted unexpectedly.
Dates are recognized as dates. Text that merely looks like a date can be treated as a category label instead of a date value.
There are no accidental totals or notes in the middle of the data. A total row can become an extra category and distort a comparison.
Each column contains a consistent kind of information. Combining labels, notes, and measurements in one column makes the chart harder to interpret.

You do not need to make a formal table first. A tidy rectangular range is enough. If your data has multiple numeric columns, such as monthly sales for three stores, include the category column and all three series in the selection.

Choose a chart type that fits the question

The best chart depends on what you want the reader to notice. In the Chart editor, open the Setup tab and choose a type from the Chart type menu. Sheets may suggest a chart automatically, but treat the suggestion as a starting point rather than a rule.

Column or bar chart: Compare values across categories, such as sales by product. Column charts use vertical bars; bar charts use horizontal bars, which can be easier to read when category names are long.
Line chart: Show a trend over an ordered sequence, especially dates or time periods. A line is useful when the order of points matters.
Pie chart: Show how categories contribute to one whole. It is most readable with a small number of categories that add up to a meaningful total.
Scatter chart: Examine the relationship between two numeric variables, such as advertising spend and sales. It is not a substitute for a category-based bar chart.
Area chart: Emphasize changes in totals or quantities over time. Overlapping series can be difficult to distinguish, so use it selectively.

For instance, to compare sales across 12 months, a column chart or line chart can both work. Use columns when comparing individual months is the main point; use a line when the overall direction or movement is more important. Avoid choosing a chart only because it looks decorative. A chart should make the comparison easier to understand.

Create the chart step by step

Open the spreadsheet in Google Sheets in a web browser and arrange the data in rows and columns.
Select the cell range to chart. Include the header row and category labels. For example, select A1:B13 if A1 contains Month, B1 contains Sales, and the data runs through row 13.
Choose Insert > Chart from the menu. Sheets inserts a chart and opens the Chart editor, typically on the right side of the screen.
On the Setup tab, review the data range and chart type. If Sheets interpreted rows and columns incorrectly, check the settings for using the first row as headers or the first column as labels. You can also use Switch rows/columns when the series should be organized in the opposite direction.
Close the editor when you are done. Click the chart to select it again; reopen the editor using its three-dot menu and Edit chart if you need to make changes.

If you did not select data first, you can still create a chart with Insert > Chart, then enter or adjust the range on the Setup tab. The range field accepts spreadsheet references, and the editor also lets you add or remove series. Check the preview and labels before assuming the automatic selection is correct.

Customize the title, labels, colors, and legend

Use the Chart editor’s Customize tab to make the chart clearer. The available controls depend on the chart type, so a setting shown for a column chart may not appear for a pie or scatter chart.

Open Chart & axis titles to choose a title or subtitle and enter text. A specific title such as “Monthly sales, 2025” is more informative than “Sales chart.” You can also adjust the title’s font, size, and formatting.
Open Legend to change its position or formatting. A legend is useful when the chart has several series; for a single series, it may add little information.
Use Series options to adjust series appearance. Depending on the chart, you can set colors or turn on data labels that print values on or beside the marks.
Open the horizontal or vertical axis settings to adjust available label and formatting options. Axis titles can clarify what the numbers measure, such as “Dollars” or “Units sold.”
Use gridline and tick-mark settings where available to make values easier to estimate without crowding the chart.

Data labels are helpful when readers need exact values, but showing a label for every point in a large series can clutter the graph. Similarly, use a restrained color scheme and reserve distinct colors for series that need to be compared. Do not rely on color alone to convey meaning if the chart will be read by people with color-vision differences.

You can reposition the chart by dragging it on the sheet and change its size by dragging a corner or edge. The surrounding cells remain part of the spreadsheet; moving or resizing the chart changes its placement, not the underlying data.

Edit the range or fix a chart that looks wrong

If the graph omits a category, includes an unintended value, or displays the wrong labels, select it and open Edit chart. On the Setup tab, check the data range, series, and category labels. For example, if a chart includes a total row, edit the range so that it ends at the last actual category rather than the total.

Common problems and practical fixes include:

The chart has the wrong orientation: Use Switch rows/columns or change which row is used as headers and which column is used as labels.
Numbers appear as categories or are missing: Check that the source cells contain numeric values, not text with extra characters or spaces. Apply an appropriate number format if needed.
Dates appear in an odd order: Confirm that the source cells are real dates and sort the source data into the order you intend. A chart follows the data’s category order rather than necessarily arranging text labels chronologically.
The chart looks crowded: Remove unnecessary series, shorten category labels, or select a chart type that handles many categories better. A pie chart with many slices is especially hard to read.
New rows do not appear: Edit the chart’s data range to include the additional rows. If the dataset will grow, select a range with room for future entries, then check that the extra blank rows do not create unwanted categories.

When the chart seems to contradict the spreadsheet, inspect the selected range before changing colors or formatting. The issue is often a heading, blank cell, text-formatted number, or unintended row included in the source.

Move, copy, and share a chart

A chart can sit on the same sheet as the source data, which is convenient for a quick report. Select it and use its three-dot menu to access chart actions. Depending on the available menu options, you can move a chart to its own sheet or copy it. A separate chart sheet gives the graph more room, while an embedded chart makes it easy to view alongside the figures it summarizes.

To share the chart with others, share the Google Sheets file using the spreadsheet’s sharing controls. Their ability to view or edit the chart follows the access you grant to the file. If you need a chart image for a document or presentation, use the chart’s menu to copy the chart where that option is available, or use an appropriate download or export option. Check the result after pasting or exporting, since sizing and appearance can differ from the sheet.

Remember that sharing a chart inside a spreadsheet also shares the surrounding workbook according to the file’s permissions. If the sheet contains information the audience should not see, prepare a separate file or remove that information before sharing rather than assuming the chart alone limits access.

Google Sheets charts compared with Excel charts

The basic idea is similar in both programs: select data, insert a chart, and customize it. In Google Sheets, the browser menu path is Insert > Chart, and chart settings appear in the Chart editor with Setup and Customize tabs. In Excel for Microsoft 365 on Windows, chart commands are on the Insert tab of the ribbon, where the chart groups and recommended chart options are organized differently.

Because Sheets and Excel are separate applications, a chart’s formatting or behavior may not transfer perfectly when a workbook is converted or opened in the other program. If you are collaborating in Google Sheets, use its Chart editor rather than following Excel ribbon instructions. If you later export a file for Excel, review the chart in the destination program and confirm that the labels, data range, and formatting still make sense.

Frequently Asked Questions

How do I make a graph in Google Sheets with two sets of data?
Select the category labels and both numeric columns, including their headings, then choose Insert > Chart. In the Setup tab, confirm that the headings are treated as series names and the first column is used for labels. Choose a chart type that makes the two series easy to compare.

How do I change a graph type in Google Sheets?
Click the chart, open its three-dot menu, and choose Edit chart. In the Chart editor’s Setup tab, select a different option from Chart type. The chart uses the same data range unless you change it too.

Can a Google Sheets graph update when I change the data?
Yes. Changes to values in the chart’s source range are generally reflected in the chart. New rows may fall outside that range, however, so edit the range in the Setup tab if added data is not displayed.

How do I add numbers to the bars or points?
Select the chart and open Edit chart. In the Customize tab, look under Series for the Data labels option. Its availability and exact controls depend on the chart type.

Why is Google Sheets making the wrong graph from my data?
Sheets may have interpreted the selected range, headers, or category column incorrectly. Open the Setup tab, verify the range, and check the header and label settings. Also confirm that values are stored in the intended format and that no unwanted totals or blank rows are included.

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.