Creating a chart starts with selecting your data, then letting Google Sheets build the chart for you
A chart in Google Sheets takes the numbers you have already entered and turns them into a picture — a bar graph, line chart, pie chart, or one of a dozen other shapes. You do not need to know how to draw or code anything. You highlight the cells that hold your data, click one button, and Google Sheets offers you chart options. Most of the time, the first suggestion is the one you want.
The process takes about two minutes from start to finish. If you have never made a chart before, the hardest part is usually deciding which type of chart tells your story best — not the technical steps.
Key Takeaways
- Select the cells containing your data — including headers — before you insert a chart.
- Go to Insert > Chart, and Google Sheets will suggest a chart type based on what it sees in your data.
- The Chart Editor panel on the right side lets you change the chart type, add a title, and adjust colors without leaving the spreadsheet.
- You can move a chart anywhere on your sheet by clicking and dragging it, and resize it by pulling the corners.
- Charts update automatically when you change the numbers in your spreadsheet.
Select the data you want to show
Open your spreadsheet and look at the numbers you want to turn into a chart. This might be monthly sales figures, test scores, website visitors, or anything else that makes sense as a picture.
Click on the first cell of your data and drag to the last cell. Include the row or column headers — the labels that say what each number represents. For example, if your data is months in column A and sales in column B, select from the cell that says "Month" all the way down to your last number. Google Sheets uses those headers to label your chart automatically.
You do not have to select a perfect rectangle. If your data is scattered across the sheet, hold Ctrl (or Cmd on a Mac) and click each separate group of cells you want to include. Google Sheets will combine them into one chart.
Open the chart menu and let Google Sheets suggest a type
With your data selected, go to the menu at the top and click Insert. A dropdown list appears. Click Chart.
Google Sheets looks at your data and suggests a chart type. If you have one column of numbers, it usually suggests a bar chart. If you have two columns and one is dates or months, it suggests a line chart. Most of the time, this suggestion is exactly what you need. A preview of the chart appears on your sheet right away.
If the suggestion does not match what you want, you can change it in the next step. For now, just let Google Sheets make its guess.
Change the chart type if the suggestion is not what you want
On the right side of your screen, a panel called the Chart Editor opens. At the top of this panel is a section labeled Chart Type. You see a picture of the chart Google Sheets suggested, and below it, a list of other options.
Click on any chart type to see how your data looks in that shape. A column chart shows numbers as vertical bars. A line chart connects points with a line, which is useful for showing change over time. A pie chart shows parts of a whole. A scatter chart shows the relationship between two sets of numbers. Try a few and see which one tells your story most clearly.
Once you pick a chart type, it stays selected. You can always come back and change it later by opening the Chart Editor again.
Add a title and adjust the appearance
In the Chart Editor panel, scroll down to find the Chart & Axis Titles section. Click in the box next to Title and type a name for your chart — something like "Monthly Sales" or "Test Scores by Student".
Below that, you can add titles to your horizontal and vertical axes if you want. This is optional but helpful if someone else will read your chart and might not know what the numbers mean.
Scroll down further to find Series. Here you can change the color of the bars, lines, or slices. Click on the color box next to the data series name, and a color picker appears. Choose a color that stands out or matches your preference.
All of these changes happen when ready on your chart. You do not have to click a button to save them.
Move and resize your chart on the sheet
Your chart appears as a box on your spreadsheet. Click anywhere on the chart to select it — you will see a border around it with small squares at the corners and edges.
To move the chart, click and drag it to a new spot on your sheet. To make it bigger or smaller, click and drag one of the corner squares. Dragging a corner keeps the chart proportional. Dragging an edge stretches it in one direction.
You can place your chart next to your data, below it, or on a different part of the sheet. Google Sheets does not care where it sits.
Charts update when your numbers change
If you go back and edit one of the numbers in your original data, the chart updates automatically. You do not have to rebuild it or click a refresh button. This is one of the biggest advantages of using charts in a spreadsheet — they stay connected to your data.
If you delete a row or column that your chart uses, Google Sheets will let you know that the chart no longer has all its data. You can then edit the chart to point to new cells, or delete the chart and start over.
Frequently Asked Questions
Can I use data from multiple sheets in one chart?
Yes. When you select your data, you can include cells from different sheets by typing the sheet name before the cell reference — for example, Sheet2!A1:B10. Google Sheets will combine data from all the sheets you reference into a single chart.
What if Google Sheets suggests a chart type I do not want?
Open the Chart Editor panel on the right, scroll to Chart Type, and click on a different option. You can switch between any chart type at any time. Try a few to see which one shows your data most clearly.
How do I remove a chart from my spreadsheet?
Click on the chart to select it, then press Delete on your keyboard. The chart disappears, but your original data stays in place. You can always create a new chart from the same data later.
Can I copy a chart to another sheet or document?
Yes. Click on the chart to select it, press Ctrl+C (or Cmd+C on a Mac) to copy it, then go to another sheet or document and press Ctrl+V (or Cmd+V) to paste it. The chart will paste as an image, so changes to the original data will not update the copy.
What chart type should I use for comparing numbers across categories?
A column chart (vertical bars) or bar chart (horizontal bars) works best for comparing amounts across different groups. A line chart is better for showing how something changes over time. A pie chart shows how parts add up to a whole, but only works well with a few categories.