Google Sheets Data Chart: Create, Customize, and Fix It

To make a data chart in Google Sheets, select the cells you want to visualize, then choose Insert > Chart. Sheets creates a chart and opens the Chart editor, where you can choose a chart type, adjust the data range, and customize how the result looks.

What a Google Sheets data chart does

A chart turns values in a spreadsheet into a visual summary. Instead of asking readers to compare many numbers in a table, you can use bars to compare categories, a line to show change over time, or a scatter plot to reveal how two numerical variables relate. In Google Sheets, a chart is connected to cells in the spreadsheet, so editing the source values can update the chart.

Charts are useful for more than presentations. They can help you spot an unusual value, compare performance across locations, or see whether a measurement is increasing or decreasing. For example, a monthly sales table with one column for month and another for revenue can become a line chart that makes seasonal patterns easier to notice.

A chart is only as meaningful as the data and choices behind it. A misleading scale, unclear labels, or a chart type that does not fit the question can obscure the pattern—or imply one that the data does not support. A useful chart therefore starts with a clear question, such as “Which product sold the most?” or “How did weekly visits change?”

Prepare the data before inserting a chart

Organize the source data so Sheets can identify what each value represents. A simple table usually works best: put descriptive headings in the first row, categories or dates in the first column, and numeric measurements in the remaining cells. Avoid blank rows or columns inside the table, merged cells, and explanatory notes mixed into the data range.

For example, a monthly revenue table could have Month, North, and South as its headings, followed by one row per month. Sheets can then interpret the months as category labels and the two regions as separate series. If the chart instead displays months as separate series, the table may need to be switched between rows and columns in the Chart editor.

Use one consistent format for dates, such as actual spreadsheet dates rather than a mixture of dates and text labels.
Keep numeric values numeric. A value entered as text may not behave like a number in a chart.
Include units in a heading or label, such as Revenue (USD), rather than leaving readers to guess.
Give each series a clear heading. Generic names such as Column B are less useful in a legend.

When a table contains totals, notes, or unrelated columns, select only the cells relevant to the chart. You can also adjust the chart’s data range after creating it. If you append new data below the selected range later, check that the chart includes it; whether an expanded range is incorporated can depend on how the data was added and how the chart range is defined.

Create a chart in Google Sheets

Select the data cells, including the headings you want to use as labels.
Choose Insert > Chart from the menu. Sheets inserts a chart and displays the Chart editor, usually in a panel on the right.
On the Setup tab, review the chart type and data range. Sheets may suggest a chart based on the selected data, but you can choose another type from the chart-type menu.
Check the options for using the first row as headers and the first column as labels. Turn them on or off as appropriate for your layout.
Use the Customize tab to change the title, legend, axes, series, and other presentation details.

You can move the chart by dragging it and resize it using its handles. To edit it later, click the chart and use the three-dot menu or double-click the chart to reopen the Chart editor. The chart remains on the sheet as an object; it does not replace or rearrange the source data.

Choose the right chart type

Pick a chart type that matches the comparison you want to make, rather than choosing one only because it looks attractive. These are common uses:

Column or bar chart: Compare amounts across categories, such as sales by product. Bars are often easier to read when category names are long.
Line chart: Show a trend across ordered values, especially dates or time periods. Connecting points makes sense when the order is meaningful.
Pie chart: Show how a small set of categories contributes to one whole. It is clearest when the categories are mutually exclusive and there are not too many slices.
Scatter chart: Compare two numerical variables, such as advertising spend and orders. Each point represents a pair of values; it is not simply a line chart with a different appearance.
Area chart: Emphasize amounts or changes over an ordered sequence. Overlapping filled series can be difficult to interpret, so use it carefully.
Combo chart: Display different series with different chart styles, for example columns for orders and a line for a target. If the measures use very different scales, an axis choice can affect how readers interpret the relationship.

A common misconception is that a pie chart is automatically the best way to show percentages. If readers need to compare close values, a bar chart is often easier because people can judge lengths more accurately than small differences between slice angles. Likewise, a line chart is usually a poor choice for unrelated categories because the connecting line suggests continuity.

Customize titles, labels, axes, and colors

Open Customize in the Chart editor to refine the chart. The available sections vary by chart type, but commonly include Chart & axis titles, Legend, Series, Horizontal axis, Vertical axis, and Gridlines and ticks. Choose the chart title and axis-title options to describe what is being measured, and include units where they matter. “Weekly visitors” tells a reader more than “Results.”

The Legend section controls where the series key appears, or whether it is shown. In Series, you can change the appearance of individual data series and, for supported chart types, add data labels. Labels can make exact values visible without requiring a reader to estimate them from an axis, but placing a label on every point in a large chart can make it cluttered.

Axis settings help control readability. A vertical axis that begins well above zero can make small differences in a bar chart look dramatic, so check the scale before sharing a comparison. Conversely, a line chart may need a narrower scale to show modest changes, provided the axis is clearly labeled and the visual impression is not misleading. Gridlines can help readers estimate values, but too many can compete with the data.

Use color consistently and with enough contrast. If a chart uses color to distinguish categories, do not rely on subtle shades alone; some viewers may have difficulty distinguishing them. Keep the chart background and decorative effects restrained so the data remains the focus. A clear title, readable labels, and a sensible scale usually matter more than elaborate styling.

Examples of charts for common spreadsheet questions

Suppose a store tracks monthly orders for three product lines. Put months in the first column and each product line in its own column. A line chart can show how each product changes month to month, while a column chart can emphasize comparisons among products in a particular month. If the lines cross repeatedly, the chart may be telling you that the products have different seasonal patterns—not necessarily that one consistently performs better.

For a survey with counts of responses such as Yes, No, and Unsure, a bar chart makes the category totals easy to compare. A pie chart can work if the categories make up the complete response group and the number of categories is small. Include the sample size or relevant context in the title or nearby text when the chart might otherwise give an incomplete impression.

For a project tracker with dates and completed tasks, a line chart can show progress over time if the values are recorded at regular or interpretable intervals. A scatter chart is more suitable when the question is whether two numerical measures move together—for instance, hours of training and assessment scores. A visible association does not establish that one measure caused the other; other factors may explain the pattern.

Fix common chart problems

If the chart has the wrong labels or treats headings as data, return to Setup and check the data range and the header and label options. For example, if a heading appears as a bar, Sheets may not be recognizing the first row as headers. If months appear in the legend instead of along the horizontal axis, try Switch rows/columns in the Setup options.

Only one series appears: Confirm that the selected range includes all the measurement columns and that the columns contain usable numeric data.
Blank or unexpected points appear: Inspect the source cells for empty entries, text mixed with numbers, or formulas that return empty text.
The chart omits recent rows: Check the data range in Setup and extend it to cover the new records.
Dates look out of order: Make sure they are stored as dates and review the order of the source rows. Text that merely resembles a date may be treated as a category label.
Values look misleading: Review the axis bounds and units, and consider whether the chart type makes the comparison clear.

When a chart does not update as expected, first click it and inspect the range shown in the Chart editor. Then check whether the source cells actually changed and whether the new rows fall inside that range. Avoid rebuilding the chart before checking these settings; the cause is often a range or data-layout issue rather than a failure of the chart itself.

Share charts and work with Excel

A chart inside a Google Sheets file is shared along with the spreadsheet, subject to the file’s sharing permissions. A recipient who can view the sheet can see its chart, while editing access depends on the permission granted for that file. Before sharing, check that the chart does not expose information in hidden or otherwise sensitive data; hiding cells should not be treated as a security measure.

Google Sheets also supports copying a chart into Google Docs or Slides. Depending on the paste choice, you can link the inserted chart to the spreadsheet or paste it without a live link. A linked chart can be updated from its source, while an unlinked copy will not automatically reflect later spreadsheet edits. Check the destination document or presentation after pasting so you know which version you have.

Google Sheets and Microsoft Excel both create charts from selected spreadsheet ranges, but their chart editors and menus are different. In Sheets, use Insert > Chart and the Setup and Customize tabs. Excel for Microsoft 365 on Windows uses its own Insert and Chart Design tools, so Google Sheets menu directions do not apply there. When moving a workbook between the applications, verify the chart type, labels, formatting, and data range: visual details can change during conversion.

Frequently Asked Questions

How do I make a chart from two columns in Google Sheets?

Select both columns, including their headings, then choose Insert > Chart. Review the chart type, data range, and header and label options in Setup. For example, a category column and a number column can form a basic bar or column chart.

How do I change a chart type in Google Sheets?

Click or double-click the chart to open the Chart editor, go to Setup, and select a different option from the chart-type menu. Check the result afterward because some chart types expect a particular data arrangement.

How can I add a title to a Google Sheets chart?

Open the Chart editor, choose Customize > Chart & axis titles, and select the title type you want to edit. Enter a concise title that identifies the subject and, where useful, the period or units.

Why is my Google Sheets chart not updating?

Check that the source cells changed and that the chart’s data range includes them. If you added records beyond the existing range, edit the range in Setup. Also check whether the new values are numeric or dates rather than text.

Can I make a chart update automatically when I add data?

A chart updates when its source data changes, but it may not include newly added rows if they are outside its defined range. Review the range in Setup and adjust it to cover the intended data. For a chart used as a recurring report, checking the range after adding rows is a practical safeguard.

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.