Google Sheets Chart Editor: Create and Customize Charts

The Google Sheets Chart editor is the sidebar for creating and changing charts in a spreadsheet. Select the cells you want to visualize, choose Insert > Chart, then use the Setup tab to select a chart type and data range and the Customize tab to adjust its appearance.

Where to find the Chart editor

In Google Sheets in a web browser, select a cell in your data or highlight the range you want to chart, then choose Insert > Chart. Sheets inserts a chart and opens the Chart editor in a panel on the right. If the panel is closed, double-click the chart or click its three-dot menu and choose Edit chart. Selecting the chart and choosing Edit chart from that menu is also useful when you want to reopen the editor later.

The editor has two main tabs. Setup controls what the chart displays: its type, source range, categories, and series. Customize controls presentation, including titles, colors, legend placement, and axes. The available options vary by chart type, so a setting you see for a line chart may not appear for a pie chart.

These instructions are for the browser version of Google Sheets. The Sheets mobile apps can display and edit spreadsheets, but chart creation and detailed formatting are generally easier to do in a desktop browser, where the full Chart editor sidebar is available.

Prepare the data before making a chart

A chart is only as clear as the range behind it. Put related information in a compact table with one header row and consistent columns. For example, a monthly sales table could have Month in column A, North in column B, and South in column C, followed by one row per month. The month values become the category labels, while the two region columns become separate series.

Before inserting a chart, check for blank rows or columns inside the table, inconsistent labels, and numbers stored as text. A value such as $1,200 may be interpreted differently if it was entered as text rather than formatted as currency. Dates should be real date values if you expect the chart to treat them as dates. Headers help the editor identify series and labels; without them, a column heading might be plotted as a data point or a series may receive a generic name.

You do not always need to highlight the whole table first. Selecting a cell inside a well-formed table and choosing Insert > Chart often lets Sheets infer the nearby data range. Still, check the range in Setup. Inferred ranges can include adjacent content you did not intend to chart, or miss data that is separated from the table.

Create a chart and set its data

After choosing Insert > Chart, use the Setup tab to confirm the chart’s source. The Data range field identifies the cells being used. You can edit that range directly, or use the grid selector to choose cells in the sheet. For the monthly example, a range such as A1:C13 includes a header row and twelve months of values.

Setup also provides controls for the chart’s axes and series. In a column chart, for example, months are usually the horizontal categories and each region is a separate series of columns. If Sheets interprets the table in the opposite direction, use Switch rows/columns. The options Use row 1 as headers and Use column A as labels tell Sheets how to interpret the first row and first column; adjust them if the chart treats labels as values.

Use the chart preview as a check rather than assuming the initial result is correct. Confirm that every expected category appears, that the series names match the headers, and that the plotted values make sense. If a series is missing, use Add series in Setup or correct the data range. If an unwanted column appears, remove it from the range or series list. A chart can be repositioned and resized on the sheet by dragging it, independently of the editor settings.

Choose the right chart type

The chart type should match the question the data answers. Setup includes a chart-type menu with options such as column, bar, line, area, pie, scatter, and other specialized charts. A practical starting point is to decide whether you are comparing categories, showing change over time, or examining a relationship between numeric variables.

Column or bar: Compare values across categories, such as sales by product. A bar chart can be easier to read when category names are long.
Line: Show a trend across an ordered sequence, often dates or months. It is useful when the direction of change matters more than the size of separate category bars.
Pie: Show parts of a whole when there are only a few categories and the values represent meaningful shares of one total. Many similar-sized slices are difficult to compare.
Scatter: Examine how two numeric variables relate, such as advertising spend and sales. It is not a substitute for a category chart when the horizontal values are labels.
Area or stacked chart: Show totals or contributions across a sequence, provided the underlying measures can sensibly be added together.

For instance, a line chart can clarify whether monthly revenue is rising, while a column chart can make it easier to compare the exact differences between individual months. Avoid choosing a chart merely because it looks attractive: a 3-D effect or a crowded pie can make values harder to judge.

Customize titles, colors, axes, and legends

Open Customize to find formatting controls. Chart style includes options for the chart background and visual treatment. Chart & axis titles lets you choose which title to edit, then enter text and adjust its formatting. Use a descriptive title such as Monthly sales by region rather than an unexplained label like Results. Axis titles are particularly useful when units are not obvious from the data, such as Revenue (USD) or Temperature (°C).

The Series section provides appearance controls for plotted data. Depending on the chart, you can adjust series colors and related display options. If a chart has several lines or bars, use clearly distinct colors and preserve the same color for the same category in related charts. The Legend section controls whether the legend is shown and where it appears. A legend can be unnecessary when categories are labeled directly, but it helps readers identify several series.

Horizontal axis, Vertical axis, and Gridlines and ticks sections provide controls that depend on the selected chart. Axis settings can affect labels, scale, and formatting; gridlines can help readers estimate values. Keep the scale honest and readable. For example, starting a vertical axis far above zero can exaggerate small differences in a bar chart. A line chart may sometimes use a focused scale for a specific analytical purpose, but the choice should not mislead readers about the magnitude of change.

Customization is not limited to decoration. If labels overlap, changing the chart size, switching to a bar chart, or reducing the number of categories may improve legibility more than shrinking the font. The best chart is one that communicates accurately at the size where people will actually view it.

Keep charts useful as data changes

A chart in a spreadsheet is connected to its source cells. When values in the included range change, the chart generally updates to reflect those changes. This makes a chart useful for recurring reports: a new sales figure entered within the chart’s data range can appear without rebuilding the graphic.

However, a chart does not necessarily include rows added beyond its current source range. If a chart covers A1:C13 and you add a new month in row 14, check Setup to see whether the data range expanded. If it did not, extend the range to include the new row. This is especially important for monthly or weekly reports where data grows over time. Keep the source table orderly and verify the chart after adding categories, changing headers, or moving cells.

To create a different view without changing the source data, duplicate the chart and adjust its Setup options, or create another chart from the same range. This can be helpful when one view compares regions and another emphasizes the overall trend. Use clear titles so readers can distinguish the charts.

Common Chart editor problems

If a chart is blank or incomplete, first inspect its data range and verify that the included cells contain usable values. Then check whether the headers and label options are set correctly. Numbers stored as text, merged cells, blank rows, and accidental extra columns can all lead to confusing results. Try selecting the intended table again and checking the chart’s Setup fields rather than repeatedly changing colors or style settings.

If the chart has the right data but the wrong orientation, use Switch rows/columns. If dates appear as separate labels in an unexpected order, confirm that the source cells are genuine dates and that the chosen chart type suits the data. If the legend shows generic names, make sure the source includes a header row and that Use row 1 as headers is enabled where appropriate.

When text is cramped, enlarge the chart or simplify what it displays. Long category labels may fit better in a bar chart; too many series may be easier to understand as separate charts. If a title or axis label seems unchanged, confirm that you selected the right title type in Chart & axis titles. Formatting choices in Customize cannot fix a mistaken data range, so diagnose the source first.

Google Sheets charts compared with Excel

Google Sheets and Microsoft Excel both let users create charts from selected spreadsheet data, choose chart types, and change labels and visual formatting. In Sheets, the principal controls are in the Chart editor sidebar, divided into Setup and Customize. Excel for Microsoft 365 on Windows uses a different interface: chart tools appear on the ribbon when a chart is selected, and chart options are organized through tabs and controls such as Chart Design and Format.

The main practical distinction is not that one program has a universal chart advantage; it is that their menus, collaboration workflows, and file handling differ. Sheets is designed for browser-based collaborative editing, while Excel has its own desktop and web versions and broader integration with Microsoft Office. If you move a spreadsheet between them, inspect the chart afterward. Some formatting or chart details may not transfer exactly, and the editing controls will not have the same names or layout.

Frequently Asked Questions

How do I open the Chart editor in Google Sheets?
Select a chart and double-click it, or click its three-dot menu and choose Edit chart. To create a new chart, select data and choose Insert > Chart; the editor opens with it.

Where is the Customize tab in Google Sheets?
It is at the top of the Chart editor sidebar, beside Setup. Click Customize to find controls for titles, chart style, series, legend, axes, and gridlines. The exact sections available depend on the chart type.

How do I change the chart type?
Open the Chart editor, select Setup, and choose a different option from the Chart type menu. Check that the new chart still uses the intended categories and series, since some chart types interpret data differently.

Why is my Google Sheets chart showing the wrong data?
Check the Data range field, then verify the X-axis, series, and header and label options in Setup. Use Switch rows/columns if the table is oriented incorrectly, and look for extra cells, text-formatted numbers, or missing headers.

Will a Sheets chart update when I change the data?
Changes to values within the chart’s source range are reflected in the chart. Newly added rows may fall outside that range, so check Setup and expand the range when you add more data.

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.