Creating a chart from your data takes three steps: select the numbers or categories you want to visualize, open the chart tool, and pick the type of chart that matches what you're trying to show
Google Sheets can turn any set of numbers into a visual chart — a bar graph, line chart, pie chart, or a dozen other formats. The process is straightforward: highlight the data you want to chart, click Insert, choose Chart, and Sheets builds a basic version automatically. From there you can change the chart type, add titles, and adjust colors to match what you need.
The hardest part is usually not the mechanics but deciding which chart type tells your story clearly. A line chart works well for showing change over time. A bar chart compares amounts across categories. A pie chart shows how parts add up to a whole. This guide walks you through the actual steps, then explains which chart type works for different kinds of data.
Key Takeaways
- Select your data first — include headers if you have them, and make sure numbers and labels are in adjacent columns or rows.
- Go to Insert, then Chart, and Sheets creates a default chart you can customize from there.
- The Chart Editor panel on the right lets you change the chart type, add a title, and adjust colors without touching your original data.
- Line charts show trends over time, bar charts compare amounts, and pie charts show parts of a whole — pick the type that matches what your data means.
- You can move a chart anywhere on your sheet by clicking and dragging it, and resize it by pulling the corners.
How to select data and insert a chart
Start by clicking on the first cell of the data you want to chart. Hold down the mouse button and drag to the last cell that contains data you want to include. This creates a highlighted rectangle — Sheets calls this a range. If your data is scattered across the sheet rather than in one block, hold Ctrl (or Cmd on Mac) and click each separate section you want to include.
Once your data is selected, go to the menu at the top and click Insert. A dropdown menu appears. Click Chart. Sheets analyzes your selection and creates a default chart — usually a column chart (vertical bars) — and opens the Chart Editor panel on the right side of the screen. The chart appears on your sheet as a box you can move and resize.
If Sheets guesses wrong about which data should be on which axis, you can fix it in the Chart Editor. Look for the Setup tab (it's usually already open). Under "Data range," you'll see your selection. If you need to add or remove data, click the range box and select a different area of your sheet.
Changing the chart type to match your data
The Chart Editor's Setup tab shows a list of chart types on the left. Column chart (vertical bars) is the default. Click any other type to see how your data looks in that format. The most common types are:
- Column chart: Vertical bars that compare amounts across categories — good for showing sales by month or test scores by student.
- Bar chart: Horizontal bars that do the same thing — easier to read when category names are long.
- Line chart: Points connected by lines that show change over time — use this for stock prices, temperature, or anything that rises and falls.
- Pie chart: A circle divided into slices, where each slice is a part of the whole — use this to show what percentage of a budget goes to each department, or what fraction of sales comes from each product.
- Area chart: Like a line chart but with the space below the line filled in — good for showing multiple trends at once.
Click the chart type you want. Sheets redraws your chart immediately. If it doesn't look right, try a different type. There's no penalty for experimenting — your original data never changes.
Adding a title and labels to your chart
In the Chart Editor, click the Customize tab (next to Setup). At the top, you'll see a field labeled "Chart title." Click it and type a title that describes what the chart shows — something like "Monthly Sales" or "Temperature by Season." Press Enter and the title appears above your chart.
Below that, you can add titles for the horizontal axis (the bottom) and vertical axis (the side). For a sales chart, you might label the horizontal axis "Month" and the vertical axis "Sales in dollars." These labels help anyone reading the chart understand what the numbers mean.
If you want to change the font size, color, or style of any text in the chart, the Customize tab has options for that too. Look for sections labeled "Chart title," "Horizontal axis title," and "Vertical axis title." You can make text bigger, smaller, bold, or a different color.
Adjusting colors and appearance
In the Customize tab, scroll down to find "Series" — this controls the color of the bars, lines, or slices in your chart. Click on a series name and a color picker appears. Click the color box to choose a new color. If your chart has multiple series (for example, sales data for two different products), you can color each one differently.
You can also change the background color of the chart itself. Look for "Chart and axis titles" or scroll to find "Background color." Click the color box and pick a shade. A white or light gray background usually works best because it keeps the focus on the data.
If you want to remove the legend (the box that explains what each color means), go to the Legend section in Customize and change "Position" to "None." This is useful if your chart only has one series and the legend takes up space without adding information.
Moving and resizing your chart
A chart sits on your sheet as a floating box. Click anywhere on the chart (not on the data inside it) and a border appears around it. You can now drag the entire chart to a new location on your sheet. This is useful if you want the chart below your data, or in a different area altogether.
To resize the chart, position your cursor at one of the corners of the border until the cursor changes to a diagonal arrow. Then click and drag outward to make the chart bigger, or inward to make it smaller. Dragging a side (rather than a corner) stretches the chart in one direction only.
If you want to delete the chart, click it once to select it, then press Delete. The chart disappears but your data stays intact.
Updating a chart when your data changes
One of the advantages of charts in Sheets is that they update automatically. If you change a number in your original data, the chart redraws itself to reflect the change. You don't have to recreate the chart or tell Sheets to refresh it — it happens on its own.
If you add new rows or columns of data near your existing chart data, Sheets usually adds them to the chart automatically. If it doesn't, click the chart, go to the Setup tab in the Chart Editor, and adjust the data range to include the new data.
Frequently Asked Questions
Can I create a chart from data in different sheets?
Yes. When you select your data range in the Setup tab, you can type a range that includes a sheet name — for example, Sheet1!A1:B10. This tells Sheets to pull data from a specific range in a specific sheet. You can combine data from multiple sheets in a single chart this way.
What if my chart looks wrong after I change the type?
Go back to the Setup tab and check the "Data range" field. Make sure it includes all the data you want and nothing extra. Also check the "Series" section — it shows which columns Sheets is treating as data and which as labels. If a label column is being charted as data (or vice versa), click the series and delete it or add the correct one.
How do I make a chart that shows multiple data series?
Select all the data you want to include — for example, columns for Month, Product A Sales, and Product B Sales. When you insert the chart, Sheets recognizes that you have multiple data columns and creates a chart with multiple series (usually different colored bars or lines). You can customize each series separately in the Customize tab.
Can I download or print my chart?
Yes. Click the chart to select it, then look for the three-dot menu icon in the top right corner of the chart. Click it and you'll see options to download the chart as an image (PNG or SVG) or to print it. You can also print the entire sheet, and the chart prints with it.
What's the difference between a column chart and a bar chart?
A column chart has vertical bars (taller than they are wide), while a bar chart has horizontal bars (wider than they are tall). They show the same information, but horizontal bars are easier to read when your category names are long, like city names or product descriptions.