Google Sheets Bar Chart: Create and Customize It

To make a bar chart in Google Sheets, select your category labels and numeric values, choose Insert > Chart, then select Bar chart in the Chart editor’s Setup tab. A bar chart displays categories as horizontal bars, making it useful for comparing values, especially when labels are long.

What a Google Sheets bar chart shows

Each bar represents a category, and its length corresponds to a value. The categories appear along the chart’s vertical axis, while the numeric scale runs horizontally. For example, a table of product names and monthly sales can become a chart where the longest bar quickly identifies the top-selling product.

Google Sheets distinguishes a bar chart from a column chart: bars run horizontally, while columns run vertically. Both can compare categories, so the choice often depends on the labels and the story you want the chart to tell. Horizontal bars generally leave more room for lengthy names; columns can be a natural fit for short labels or a timeline with a small number of periods.

A bar chart is not the same as a histogram. A bar chart compares named categories, such as departments or products. A histogram groups numeric observations into ranges, such as ages 20–29 and 30–39, to show a distribution. If your purpose is to show how values are distributed across numeric intervals, choose a histogram rather than treating each individual number as a category.

Prepare data for a clear chart

Put the category names in one column and the values to compare in the next. Add a header to each column so Sheets can identify the series and provide a useful default title or legend. For example:

Column A: Product
Column B: Units sold
Rows below the headers: one product and its sales figure per row

Keep each category’s label and value on the same row. Avoid blank rows within the data, merged cells, and explanatory notes in the middle of the table. These can make Sheets guess the range or chart structure incorrectly. If you have several series, use one column for the categories and one additional column for each series—for instance, product name, sales in April, and sales in May.

Use consistent units within a series. Mixing dollar amounts with percentages, or counts with dates, makes a single value axis hard to interpret. Check that values are genuine numbers rather than text that merely looks like a number. A quick way to spot trouble is to inspect a cell’s alignment and test whether sorting or a simple sum treats it as numeric; formatting alone does not convert text into a number.

Create a bar chart in Google Sheets

Select the data range, including the headers. If the table is small, select the category and value columns together; for a larger table, drag across the exact range or enter it in the Chart editor.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually in a panel on the right.
In the Setup tab, open the Chart type menu and choose Bar chart. If Sheets has guessed another chart type, choosing the type explicitly changes it.
Review the data range, X-axis, and Series fields in Setup. For a basic comparison, the categories should be the labels and the numeric column should be the series.
Use the Customize tab to adjust the title, colors, labels, axes, and legend. Close the editor when you are done; the chart remains on the sheet.

The chart is an object over the spreadsheet grid, not a replacement for the source table. Drag it to move it, or use its handles to resize it. To edit it later, double-click the chart to reopen the Chart editor. Changes to cells in the chart’s data range normally flow through to the chart, so you can update the source figures without rebuilding the visual.

Choose the right bar chart layout

A standard bar chart is best when each category has one value. With multiple series, a grouped chart places the series beside one another within each category, which helps readers compare them directly. For example, grouped bars can compare this year’s and last year’s sales for each product.

A stacked bar chart puts series segments together in one bar per category. It emphasizes the total and how each series contributes to it, but comparing a middle segment across categories can be difficult because those segments do not share a common starting point. A 100% stacked chart scales each category to the same total, making proportions easier to compare while hiding differences in the categories’ absolute totals.

These options are useful for different questions:

Use standard bars to compare one measure across categories.
Use grouped bars to compare separate measures category by category.
Use stacked bars to show both the total and its component values.
Use 100% stacked bars to compare each category’s composition as a share of its total.

In the Chart editor’s Setup tab, choose the available stacking option when the selected chart type and data support it. Do not choose stacking merely because there are several columns: if the goal is to compare the series’ individual values, grouped bars may communicate that more clearly.

Customize titles, axes, colors, and labels

Open Customize in the Chart editor to make the chart easier to read. Under Chart & axis titles, select the title or axis title you want to edit and enter concise wording. A title such as “Units sold by product” tells readers what the numbers mean more clearly than a generic title like “Sales.” Axis titles are especially helpful when units are not obvious from the data labels.

Under Series, you can adjust series appearance and, where supported, add data labels. Labels can make exact values visible without requiring readers to estimate bar lengths from the axis. They are most helpful for a small or moderate number of bars; on a crowded chart, labels may overlap or become harder to scan. Use a sensible number format so values display as currency, percentages, or whole numbers when appropriate.

Use the axis and gridline options to improve scale readability. A value axis should have a range and tick marks that make the differences understandable. If you set minimum or maximum bounds manually, check that you have not exaggerated small differences or concealed meaningful ones. For ordinary comparisons of positive values, showing the zero baseline is often important because bar length visually encodes magnitude.

Choose colors for contrast and meaning, not decoration. A single series often needs only one clear color. With multiple series, use distinct colors and keep their meanings consistent across related charts. Check that text and bars remain distinguishable against the chart background, including for readers who may not distinguish some color combinations easily. The legend should identify series, not compensate for unclear labels.

Adjust the data range and chart orientation

If the chart includes the wrong cells, double-click it and review Setup. Update the data range or remove an unwanted series, then confirm that the category labels and numeric values are assigned correctly. The Setup controls also include options such as using a row as headers, using a column as labels, and switching rows and columns. These options help when a table is arranged in the opposite orientation from the chart Sheets initially creates.

For instance, a table with months down the first column and several product columns can chart months as categories and products as series. If the result instead treats each month as a separate series, try Switch rows/columns and check the preview. The right arrangement depends on which dimension you intend readers to compare; inspect the legend and category axis rather than assuming the first interpretation is correct.

If you want categories in a particular order, arrange or sort the source data accordingly and check the chart afterward. This is often more predictable than expecting the chart to infer a ranking. When sorting, include the whole table range so labels stay paired with their values. For ranking charts, sorting values from largest to smallest can make the most important results easier to find.

Common bar chart problems and fixes

The chart is blank or missing bars: Check that the selected range includes numeric values and that the values are not stored as text. Review the data range and series in Setup.
Categories and series are reversed: In Setup, try Switch rows/columns, then confirm that the category labels appear on the vertical axis and the series names make sense in the legend.
The chart includes an unwanted row or column: Edit the data range or remove the extra series. A title, note, or total row accidentally included in the range can be interpreted as chart data.
Labels are cut off or crowded: Widen the chart, shorten category names in the source data, or use a horizontal bar chart for long labels. Reduce unnecessary labels if the chart has many categories.
Small differences look dramatic: Review the value-axis bounds and baseline. A narrow scale can magnify visual differences, so use bounds that suit the comparison and explain any nonzero starting point clearly.
New rows do not appear: Check whether the chart’s data range includes those rows. If not, expand the range in Setup. Do not assume a chart will include data placed outside its defined range.

Also consider whether a chart is the right way to present every value. A chart with dozens of categories can become difficult to scan even when technically correct. Filtering the source data to a relevant subset, splitting the comparison into several charts, or using a table alongside the chart may make the result more useful.

Share, copy, and export a chart

A chart stays connected to its data in the spreadsheet, which is useful when figures change. People with access to the sheet can view the chart there, subject to the file’s sharing permissions. Be careful with publishing: publishing a chart or spreadsheet to the web can expose information beyond the people who have been directly invited. Check the sharing and publishing choices before using them for confidential or personal data.

To create a standalone image, open the chart’s three-dot menu and look for its download options. Google Sheets provides chart download formats such as PNG, PDF, and SVG; availability can depend on the interface and chart context. A downloaded image is a snapshot, so later edits to the source data will not update that separate file. If you paste a chart into another document, consider whether a linked chart or a static image better fits the audience and how often the data changes.

These instructions refer to Google Sheets in a web browser. Excel has its own chart insertion and formatting controls, so its menu names and editor layout differ, even though the basic distinction between horizontal bars and vertical columns is similar.

Frequently Asked Questions

How do I make a bar chart in Google Sheets?
Select the labels and values, choose Insert > Chart, and select Bar chart from the Chart type menu in the Chart editor’s Setup tab. Use Customize to change its title, colors, labels, or axes.

How do I switch a bar chart to a column chart?
Double-click the chart, open Setup, and choose Column chart from the Chart type menu. A column chart displays values with vertical bars rather than horizontal ones.

How do I add values to the bars?
Double-click the chart, go to Customize > Series, and enable Data labels if the option is available for the chart. If labels make a busy chart difficult to read, show fewer categories or rely on the value axis instead.

Can a Google Sheets bar chart show more than one data series?
Yes. Add another numeric column to the selected range and check Setup to confirm that it is treated as a separate series. Choose grouped bars to compare series side by side, or stacking when totals or proportions are the focus.

Why are my category names showing as bars?
Sheets may have interpreted the rows and columns in the wrong direction or included the label column as a numeric series. Check the data range and the header and label options in Setup, then try Switch rows/columns.

Does a Google Sheets bar chart update when the data changes?
Yes, edits to values within the chart’s data range are reflected in the chart. New data outside that range may not appear until you expand the range in the Setup tab.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.