How to Make a Bar Graph in Google Sheets

To make a bar graph in Google Sheets, select your category and value columns, choose Insert → Chart, then set Chart type to Bar chart in the editor's Setup tab. Check the header and category labels before changing the title, colors, or data labels.

This walkthrough uses the desktop web version of Sheets and four fictional campaign budgets. A horizontal bar chart makes the channel names easy to read. If you expected upright bars, choose a Column chart instead: the underlying category comparison is the same, but the axes change places.

The menu path follows Google's chart editing instructions. Interface labels can vary by language. Keep the chart inside Sheets if your workbook is the main deliverable; a separate bar chart maker is useful when you want a browser-generated PNG or SVG for a report.

1. Put categories and numbers in separate columns

Download the fictional channel budget CSV and import it into a blank spreadsheet with File → Import. Choose the file from your device and confirm that it appears as two columns. You can also type the following values into cells A1:B5.

Channel,Budget
Search,420
Social,240
Email,180
Events,160

Channel is the category; Budget is the measured amount. Search receives 420 of the total 1,000 budget units, followed by Social at 240, Email at 180, and Events at 160. These invented numbers demonstrate the workflow and do not describe a real company or campaign.

Give the value column a number format rather than typing a currency name into every cell. For a real report, state the currency and period in the title or axis label. Keep a Total row outside the selected chart range: comparing four channels with their combined total adds a different kind of quantity to the same chart.

2. Insert a horizontal bar chart

1. Select A1:B5, including the column headers and all four categories.
2. Choose Insert → Chart. Sheets may initially suggest another chart type.
3. In Chart editor, open Setup and choose Bar chart from Chart type.
4. Confirm the data range is A1:B5. Use row 1 as headers and column A as labels where those options are shown.
5. Check that Search, Social, Email, and Events are category labels and Budget is the numeric series. If they are reversed, inspect Switch rows / columns and the selected range.

Check the first bar against its source cell before styling anything. If Search appears as 1 or the chart treats Budget as a category, fix the field selection or cell type first. A more attractive palette will not correct a wrongly interpreted table.

3. Choose bar, column, or grouped bars

Use horizontal bars when category labels are long or ranking matters. A column chart gives each category an upright bar and works well for a short set of names. Google lists these as separate chart types; its column chart reference explains that variation.

To compare planned and actual spending, add a third column with the same unit and include it in the chart range. Confirm that each category has two series. Use an ordinary, unstacked chart when the goal is comparing those two values side by side. A stacked chart emphasizes their combined length, which may not be a meaningful total for planned versus actual amounts.

If the question is how spending changed each month, a Google Sheets line graph may be clearer. If the question is how this one budget is divided, the same two-column sample can become a pie chart in Google Sheets.

4. Add a useful title and readable labels

Double-click the chart to reopen Chart editor. In Customize, use Chart & axis titles to name the measure and period. In Series, enable data labels if readers need the four exact amounts. One numeric series often needs no legend if the title and labels already identify it.

Keep a visible zero baseline when bar length represents magnitude. Sort the complete source range, not the value column alone, if you want a ranked chart. Sorting only the numbers can attach a correct amount to the wrong channel. Keep a meaningful sequence for categories such as stages or age bands instead of automatically sorting every chart.

Choose restrained colors and remove decorative effects. Four channel names remain necessary even if each bar has a different color; color alone is not an adequate category label.

Common problems and fixes

Download the chart or make a separate export

Open the chart's three-dot menu and choose Download. Sheets offers PNG, PDF, and SVG chart downloads; Google's save or publish instructions describe the options. Downloading a chart image does not require publishing the spreadsheet to the web.

To recreate the chart in Charttoolbox, copy A1:B5 directly from the Sheets grid. Open the bar chart generator, choose Paste data, paste the cells with their headers, then select Channel as Category and Budget as the value field. Choose horizontal orientation, add your title, and download PNG or SVG. Copy cell values, not the chart image or a sharing URL.

This creates a separate chart; it does not stay synchronized with Sheets. Charttoolbox processes the pasted table locally. Optional analytics loads only with consent and does not receive spreadsheet contents. Keep your original workbook so the chart can be recreated when the budget changes.

Frequently asked questions

Is a bar graph the same as a column chart?

Both compare category values. In Google Sheets, Bar chart uses horizontal bars and Column chart uses vertical bars. Pick the orientation that makes the labels and comparison easiest to read.

Can I make a bar graph with two series?

Yes. Put the category in the first column and the two numeric series beside it, include their headers, then check both series in Setup. Keep their units comparable.

Why does a pasted CSV appear in one column?

CSV text uses comma delimiters. Import the downloaded CSV through File → Import, or use Data → Split text to columns and choose the correct separator. Copying an actual range from Sheets into Charttoolbox supplies a tab-separated table.