How to Edit a Chart in Google Sheets: A Step-by-Step Guide

To edit a chart in Google Sheets, select it and double-click, or click its three-dot menu and choose Edit chart. Use the Setup tab in the Chart editor to change the chart type or data, and Customize to adjust titles, colors, labels, and axes. These steps apply to Google Sheets in a web browser; Excel uses different chart-editing tabs and menus.

What You’ll Need

A Google account with access to a spreadsheet containing a chart. You need edit permission to change the chart and save those changes.
A web browser and a clear idea of what you want to change, such as the chart title, source data, chart type, or colors.
If the chart needs different information, a correctly arranged data range in the spreadsheet. Column or row headings help Sheets identify series and labels.

Step-by-Step

Open the spreadsheet and select the chart. Go to Google Sheets in your browser and open the file. Click the chart once to select it. You should see a border and small handles around it. If you do not see a chart, check that you opened the correct sheet tab and that the chart has not been deleted or moved.
Open the Chart editor. Double-click the selected chart, or click its three-dot menu in the upper-right corner and choose Edit chart. The Chart editor opens in a panel on the right. It has two main tabs: Setup and Customize. If the panel is narrow, scroll within it to find settings farther down.
Check or change the chart’s data. In Setup, review the Data range field. It identifies the cells used to build the chart. To change the range, click the field and enter or select the desired cells, including any headers you want Sheets to use. For example, if a chart should include a new month of sales, expand the range to include that month’s label and values. Make sure the selected cells contain the intended data and do not include unrelated totals or blank sections.
Adjust the chart’s structure. Still in Setup, use Chart type to choose a different display, such as a column, line, bar, or pie chart. The available options and settings depend on the type. Review the X-axis and Series sections to confirm that the category labels and plotted values are assigned correctly. Use Add X-axis or Add series when you need to assign a range that is not already included. Remove a listed series with its remove control if it should not appear. You can also check whether Switch rows / columns makes the data easier to read, and whether the options to use the first row or first column as headers are set appropriately.
Change the chart title or axis titles. Open Customize, then expand Chart & axis titles. Use the title-type menu to choose the chart title, subtitle, horizontal-axis title, or vertical-axis title. Enter the wording in the title text field. Keep titles specific: a chart called Monthly Orders is clearer than Chart 1, while axis titles should name the measure and, where useful, its unit.
Format labels and the legend. In Customize, open Legend to change its position or appearance. To show values directly on the chart, open Series and look for Data labels; the available label settings depend on the chart type. In the same area, you can often change a series color or line style. If the chart has multiple series, use the series selector in the editor to choose which one to format. Check the result in the chart so labels do not cover one another or make the display crowded.
Format the axes and gridlines if needed. In Customize, expand Horizontal axis or Vertical axis to adjust available text and number settings. For a value axis, a minimum or maximum can help focus the view, but avoid limits that hide meaningful variation. Expand Gridlines and ticks to adjust the display of reference lines when those options are available. A chart type may not offer every axis control, so switch types or review the current settings if an expected option is missing.
Review the chart and close the editor. Changes appear on the chart as you make them, and Google Sheets saves edits to the spreadsheet automatically when you are online. Click elsewhere in the sheet to close the Chart editor. Check that the chart is readable at its displayed size, its labels match the data, and the updated range includes the intended cells. If the result looks wrong, reopen the editor and adjust the relevant setting rather than rebuilding the chart immediately.

Common Mistakes

Editing the wrong chart or sheet. A spreadsheet can contain multiple charts, and each sheet tab can have its own data. Confirm the chart is selected before opening Edit chart, then check the data range shown in Setup.

Selecting an incomplete range. Including the values but not their category labels can produce generic labels or an unexpected axis. Conversely, including a title row or grand total as ordinary data can distort the chart. Review the range and header options together.

Choosing a chart type that does not suit the data. A pie chart is difficult to interpret with many categories, while a line chart is usually most useful when the horizontal categories have a meaningful sequence, such as dates. If the display looks confusing after changing type, return to Setup and try a type that fits the comparison you need to make.

Changing a color without checking the series. In a multi-series chart, a formatting choice may apply only to the series currently selected in the editor. Verify which series you are editing and check the legend so the colors still distinguish the data clearly.

Making the chart too busy. Too many data labels, gridlines, or series can make the main comparison harder to see. Add only the labels and styling that help someone understand the data, and remove unnecessary detail.

Tips

Give the chart a descriptive title before fine-tuning its appearance. It makes the purpose clear when the chart is viewed outside the context of its source cells.
Keep the source data organized in a simple table with one header row or column and consistent data types. Dates should be dates, and values intended for comparison should be numeric.
When you add rows or columns, confirm that the chart’s data range includes them. Do not assume every chart automatically expands to include newly added cells.
Use a consistent, legible color scheme. If color distinguishes series, make sure the legend is visible and the colors are easy to tell apart.
Resize the chart if titles or labels are cut off. Select the chart and drag a corner handle; avoid dragging an edge handle if you want to preserve the chart’s proportions.
If you are unsure which setting caused a change, note the current appearance before adjusting more options. You can reopen the editor and revise settings one at a time to identify the effect.

Troubleshooting

The Chart editor will not open. Click the chart once to select it, then use the three-dot menu and choose Edit chart. If the chart is embedded in a sheet you can only view, ask its owner for edit access. Reloading the spreadsheet can help if the browser interface is unresponsive, but wait for pending changes to finish saving first.

The chart is blank or missing some values. In Setup, inspect Data range, X-axis, and Series. Check for a range that stops too early, text stored where numeric values are expected, or blank cells in the source. If the values are on another sheet, confirm that the range points to the correct sheet and cells.

The chart has the wrong labels or series direction. Check the first-row and first-column header options, then try Switch rows / columns. If that does not fix it, review the X-axis and Series ranges and assign the labels and values explicitly. The correct arrangement depends on whether each row or each column represents a data series.

A title, label, or color option is missing. Some controls appear only for particular chart types or after you select a specific series. Check the chart type in Setup, then look through the relevant sections under Customize. If the control is still unavailable, the chart may not support that formatting option.

Your changes do not appear to have saved. Google Sheets saves changes automatically, but an offline connection or a temporary browser problem can delay syncing. Check the connection and the save status near the top of the spreadsheet, wait for syncing to complete, then reopen the file or refresh it. Avoid closing the tab while changes are still pending.

Frequently Asked Questions

How do I edit a chart title in Google Sheets?

Select the chart, open Edit chart, and go to Customize > Chart & axis titles. Choose the chart title or another title type, then enter the text you want.

Can I change a chart’s data without making a new chart?

Yes. Open the Chart editor and update Data range, X-axis, or Series under Setup. Check the chart afterward to make sure the new cells are mapped to the intended labels and values.

How do I change a chart from a column chart to a line chart?

Select the chart and open Setup > Chart type. Choose a line-chart option, then review the horizontal axis and series. A line chart is especially useful when the category order, often dates, matters.

Why can’t I edit a chart in Google Sheets?

You may have view-only access, or the chart may not be selected. Click the chart and choose Edit chart from its three-dot menu. If editing is unavailable, request editor access from the file owner.

Do changes to the source cells update the chart?

Usually, chart values update when cells inside the chart’s selected data range change. If new rows or columns are outside that range, edit the range in Setup to include them.

Is editing a chart in Google Sheets the same as in Excel?

No. Google Sheets uses the Chart editor’s Setup and Customize tabs in the browser. In Excel for Microsoft 365 on Windows, chart tools are arranged differently, including the Chart Design and Format tabs.

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.