Google Sheets
0 Guide

How to Make a Bar Graph in Google Sheets

This is an Arcade

Learn how to make a bar graph in Google Sheets to visually compare categories of data. This step-by-step guide makes chart creation fast and easy.

1. Open Google Sheets and highlight your data
In Google Sheets, select the range of cells that includes your category labels and corresponding values. For example, highlight A1:B6.

2. Click the Insert menu and choose Chart
Go to the top menu and click Insert, then select Chart from the dropdown. Google Sheets will auto-generate a chart based on your data.

3. Change the chart type to Bar chart
In the Chart Editor panel on the right, go to the Setup tab. Click the Chart type dropdown and select Bar chart under the "Bar" section.

4. Customize labels, colors, and legend
Switch to the Customize tab in the Chart Editor to adjust axis titles, bar colors, and whether to show or hide the Legend.

5. Resize and move the chart on your sheet
Click and drag the chart to reposition it, or pull the corners to resize it for better layout on your sheet.

Google Sheets
0 Guide

Ready to create quick,
interactive product demos?

Sign up
– it's free
{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Make a Bar Graph in Google Sheets", "description": "Learn how to make a bar graph in Google Sheets to visually compare categories of data. This step-by-step guide makes chart creation fast and easy.", "step": [ { "@type": "HowToStep", "name": "Open Google Sheets and highlight your data", "text": "In Google Sheets, select the range of cells that includes your category labels and corresponding values. For example, highlight A1:B6." }, { "@type": "HowToStep", "name": "Click the Insert menu and choose Chart", "text": "Go to the top menu and click Insert, then select Chart from the dropdown. Google Sheets will auto-generate a chart based on your data." }, { "@type": "HowToStep", "name": "Change the chart type to Bar chart", "text": "In the Chart Editor panel on the right, go to the Setup tab. Click the Chart type dropdown and select Bar chart under the 'Bar' section." }, { "@type": "HowToStep", "name": "Customize labels, colors, and legend", "text": "Switch to the Customize tab in the Chart Editor to adjust axis titles, bar colors, and whether to show or hide the Legend." }, { "@type": "HowToStep", "name": "Resize and move the chart on your sheet", "text": "Click and drag the chart to reposition it, or pull the corners to resize it for better layout on your sheet." } ] }