Creating a chart from your data takes three steps

Open the spreadsheet with the data you want to chart. Highlight the cells that contain the numbers and labels you want to visualize — Google Sheets works best when you include both the column headers (like "Month" or "Sales") and the actual values below them. Then go to the Insert menu at the top, click Chart, and Google Sheets will suggest a chart type based on what it detects in your selection.

The chart appears on the same sheet as your data, usually to the right of what you highlighted. A panel opens on the right side of the screen showing chart options. From here you can change the chart type, add a title, adjust the axis labels, and customize colors. When you are satisfied, click outside the chart or press Escape, and the chart stays embedded in your spreadsheet.

If the suggested chart type is not what you need, the Chart type dropdown in the right panel shows all available options. Bar charts work well for comparing values across categories. Line charts show trends over time. Pie charts display parts of a whole. Scatter plots reveal relationships between two sets of numbers. Pick the one that matches what your data is trying to show.

Key Takeaways

  • Select your data including headers, then go to Insert > Chart to create a chart in seconds.
  • Google Sheets suggests a chart type automatically, but you can change it using the Chart type dropdown in the right panel.
  • Add a title and customize axis labels, colors, and other formatting without leaving the spreadsheet.
  • The chart updates automatically if you change the numbers in the cells it is based on.
  • You can move or resize the chart by clicking and dragging it, or delete it by clicking once and pressing Delete.

Selecting the right data range

The data you select determines what appears in your chart. If you want to chart sales by month, select the column with month names and the column with sales numbers — both the headers and all the rows of data. Do not select empty rows or unrelated columns, because Google Sheets will try to include them.

You can select non-adjacent columns by holding Ctrl (or Cmd on Mac) and clicking each column header. For example, to chart Product A sales and Product B sales side by side, select the Product A column, then hold Ctrl and select the Product B column. Google Sheets will treat them as separate series in the chart.

If you realize after creating the chart that you selected the wrong data, click the chart once to select it, then look for the Data range field in the right panel. Click the range box next to it and drag to select different cells. The chart updates when ready.

Changing chart type and customizing appearance

After Google Sheets creates your chart, the right panel shows a Setup tab and a Customize tab. The Setup tab controls what data appears in the chart and which chart type you use. The Customize tab controls how it looks — title, colors, fonts, gridlines, and legend position.

To change the chart type, click the Chart type dropdown in the Setup tab. Scroll through the options and click the one you want. Google Sheets shows a preview of how your data will look in that type. A bar chart might be better for comparing five products, but a pie chart works only if you are showing parts of a single total.

In the Customize tab, click Chart & axis titles to add a title that describes what the chart shows. Click Series to change the color of individual data lines or bars. Click Legend to move the legend to the bottom, right, or top of the chart, or hide it entirely if it takes up too much space.

Adding titles and labels that make sense

A chart without a title leaves the reader guessing what they are looking at. Click the chart, go to the Customize tab in the right panel, and click Chart & axis titles. Type a title that says what the chart shows — "Monthly Revenue 2024" is clearer than "Data".

You can also add titles to the horizontal axis (the bottom) and vertical axis (the side). If your chart shows months along the bottom, the axis title might be "Month". If the side shows dollar amounts, the axis title might be "Revenue". These labels help anyone reading the chart understand what the numbers represent.

Leave axis titles blank if the labels are already obvious — a chart showing "January, February, March" along the bottom does not need an axis title that says "Month". The goal is clarity without clutter.

Updating charts when your data changes

One of the main reasons to use charts in a spreadsheet instead of creating them separately is that they update automatically. If you change a number in one of the cells the chart is based on, the chart redraws itself when ready. You do not have to recreate it.

This works as long as you change the values in the original cells. If you add new rows of data below what the chart currently includes, the chart does not automatically expand to show them. Click the chart, look at the Data range field in the Setup tab, and drag the selection box to include the new rows.

If you delete rows or columns that the chart depends on, Google Sheets removes those series from the chart. The chart stays in place but shows only the remaining data.

Moving, resizing, and deleting charts

Click the chart once to select it. A border appears around it with handles at the corners and edges. Drag the chart to move it to a different location on the sheet. Drag a corner handle to resize it while keeping the same proportions, or drag an edge handle to stretch it in one direction.

To delete the chart, select it and press the Delete key. The chart disappears but your data remains unchanged. You can always create a new chart from the same data later.

If you want to move the chart to a different sheet in the same spreadsheet, right-click it and select Move to sheet. Choose the destination sheet from the menu. This is useful if you have a data sheet and a separate sheet for reports and visualizations.

Common chart types and when to use them

A column chart (vertical bars) compares values across categories — for example, sales by product or website visits by day of the week. It is the most common chart type and usually the first choice when you are not sure.

A line chart shows how something changes over time. Use it for stock prices, temperature trends, or monthly revenue. The line makes it straightforward to see whether values are going up, down, or staying flat.

A pie chart shows how a total is divided into parts. Use it to show what percentage of your budget goes to rent, utilities, and food. Do not use a pie chart to compare unrelated numbers — a pie chart only makes sense when the slices add up to 100 percent.

A scatter plot reveals whether two things are related. Plot height against weight, or study hours against test scores, and the scatter plot shows whether one tends to increase when the other does. It is less common in everyday spreadsheets but powerful when you need to see a relationship.

Frequently Asked Questions

Can I create a chart from data on multiple sheets?

No, a single chart can only pull data from one sheet. If you need to combine data from two sheets, copy one set of data into the sheet where you are building the chart, or create separate charts on each sheet and place them side by side for comparison.

What if Google Sheets suggests the wrong chart type?

Click the chart, go to the Setup tab in the right panel, and click the Chart type dropdown. Scroll through the options and select the type that matches what you are trying to show. Google Sheets shows a preview before you confirm.

Can I export a chart from Google Sheets to use elsewhere?

Yes. Right-click the chart and select read. Choose the file format — PNG works for most purposes, PDF preserves formatting, and SVG is best if you plan to edit it later. The chart downloads as an image file you can insert into documents, presentations, or websites.

How do I make a chart that shows multiple data series?

Select all the columns you want to include — for example, Product A sales and Product B sales — before inserting the chart. Google Sheets treats each column as a separate series and displays them as different colors or line styles in the same chart. You can customize which series appear in the Series section of the Customize tab.

What happens if I delete a row of data that the chart uses?

The chart updates to remove that data point. If you delete an entire column that the chart depends on, that series disappears from the chart. The chart itself stays in place but shows only the remaining data.