Google Sheets Bar Chart Tutorial: Create and Customize

To make a bar chart in Google Sheets, select your category labels and numeric values, choose Insert > Chart, then use the Chart editor’s Setup tab to select Bar chart. Use the Customize tab to adjust the title, colors, labels, and legend. A bar chart places categories along the vertical axis and values along the horizontal axis, making it useful for comparing items with long names or values that are easier to scan as horizontal bars.

Prepare the data for a clear chart

Start with a tidy table: put each category in one column and the number you want to compare in an adjacent column. Use a single header row, avoid blank rows within the data, and make sure the values are numbers rather than text that merely looks numeric. For example:

Drink	Orders
Coffee	42
Tea	28
Cocoa	16
Lemonade	35

In this example, the first column supplies the category names and the second supplies bar lengths. Descriptive headers help Sheets identify the series and give the chart editor useful defaults. Keep units consistent: a column mixing dollars, percentages, and counts cannot be interpreted as a meaningful single comparison. If a table contains notes or totals, leave them outside the selected chart range unless they are intended to appear as categories.

Create the bar chart

Drag to select the table cells, including the headers. For the example above, select A1:B5.
Choose Insert > Chart from the Google Sheets menu. Sheets inserts a chart and opens the Chart editor, usually at the right side of the browser window.
On the editor’s Setup tab, open the Chart type list and choose Bar chart.
Check that the data range includes the intended cells and that Sheets has treated the header and category column correctly. The chart should show four bars, with each drink named as a category.

Sheets often selects a chart type automatically when you insert a chart, but you can change it at any time through the Chart editor. If the editor is closed, double-click the chart to reopen it. The chart stays linked to its source cells, so changing a source value updates the displayed bar without rebuilding the chart.

Choose the right bar chart type

A standard bar chart is best when you want to compare one value for each category. In the example, it makes the difference between 42 coffee orders and 16 cocoa orders easy to see. Choose a stacked bar chart when each category is divided into meaningful parts, such as orders by drink and by sales channel. Choose a 100% stacked bar chart when the main comparison is the proportion of each part within each category rather than its raw total.

For multiple series, arrange the source table with categories in the first column and one series per additional column. For example, a weekly table might have a row for each product and columns for online and in-store sales. A stacked chart adds those series together visually; a grouped chart presents series beside one another for each category. If readers need to compare individual values across series, grouped bars are often easier to read. If they need to understand each category’s composition, stacking can be more useful.

Bar charts are not the same as column charts in Sheets. A bar chart runs horizontally; a column chart runs vertically. Both can compare categories, but horizontal bars usually accommodate long labels better. A column chart can suit a small number of short category names or a sequence where a vertical layout is more natural. Use a line chart instead when the key message is change over an ordered time period, rather than ranking separate categories.

Customize the title, colors, and axes

Open the Chart editor’s Customize tab to make the chart easier to understand. Expand Chart & axis titles and choose the title or axis title you want to edit. Give the chart a specific title, such as “Orders by Drink,” instead of leaving a generic title that does not explain the comparison. Add an axis title when the measure or unit is not obvious, for example “Number of orders.” A vertical axis title is usually unnecessary when the category labels already identify the items.

Under Series, you can adjust the series appearance and, where available for the selected chart, enable data labels. A restrained color scheme helps readers focus on the values. Use a distinct color to emphasize one important category only when that emphasis has a clear meaning, and do not rely on color alone to communicate a distinction. Labels, a legend, or explanatory text should make the meaning understandable even to readers who cannot distinguish the colors.

The Legend section controls whether a legend appears and where it is placed. For a chart with just one series, a legend may add little; for multiple series, it helps explain which color represents each group. Gridlines and ticks can help estimate values, but too many visual guides make a chart busy. Keep the horizontal value scale appropriate to the data, and avoid changing the scale simply to make small differences look dramatic.

Add useful labels and preserve readability

Data labels can show the value at the end of each bar, reducing the need to estimate from the axis. They are especially helpful when the chart contains a few categories or when readers need exact figures. With many bars, labels may collide or make the chart crowded; in that case, keep a readable axis and let readers compare approximate lengths. If a label option is not available for the selected chart type or series arrangement, the chart can still communicate values through its scale.

Category names should be concise but specific. Instead of abbreviating a product name in a way that only the spreadsheet owner understands, widen the chart or simplify the wording while retaining the distinction. Sort the source rows by value when the purpose is to rank categories, and keep a logical order such as low-to-high or high-to-low. The chart reflects the source order; it does not necessarily sort categories by bar size automatically. If you change the source order, the chart updates to match.

Make the chart large enough for its labels, particularly when there are many categories. Click the chart and drag a corner to resize it, or drag the chart itself to move it on the sheet. A chart that looks clear at full size may become hard to read when pasted into a small report or viewed on a phone, so check it at the size where people will actually use it.

Fix common bar chart problems

The chart shows the wrong chart type: Double-click the chart, open Setup, and choose Bar chart from Chart type. Sheets may initially choose a column or other chart type.
Categories and values appear reversed: Check the selected range and the header settings in Setup. If the chart interprets rows and columns the wrong way, use Switch rows/columns if it is available for that data arrangement, and confirm that the first row and first column are being used as headers or labels as intended.
The chart has an unexpected blank or extra bar: Inspect the selected range for blank category cells, totals, notes, or unintended rows. Adjust the data range in Setup or reselect only the rows that belong in the comparison.
Bars have no useful names: Include the category-label column in the selected range. If labels still look wrong, check that the header row and label column are recognized correctly in Setup.
Values are missing or bars look much shorter than expected: Check for numbers stored as text, blank cells, or values with inconsistent units. Also inspect the value scale: a high maximum can make small differences look subtle, while an overly narrow scale can exaggerate them.

When a chart does not update as expected, check its data range before recreating it. A chart may exclude newly added rows if its range was set to a fixed set of cells. Update the range in Setup so it includes the new data. Keeping the source table compact and consistently structured makes later additions easier to manage.

Share, copy, and use the chart elsewhere

Because the chart is part of a Google Sheets file, people with appropriate access to that file can view it alongside its data. To give someone the chart in another document, select it and use the chart’s three-dot menu to find options such as copying or downloading, when available. The available download formats and menu options can depend on the current Sheets interface. If you copy a chart into another Google file, check whether it remains linked to the source spreadsheet or is pasted as a static image, and choose the option that suits the task.

You can also place a chart on its own sheet using the chart’s menu and the option to move it to a separate sheet. This gives the visualization more room and can be useful for a presentation-style view. It does not replace the underlying data: the chart still depends on the source range. Before sharing a file publicly or with a wider audience, review the spreadsheet’s sharing permissions and the data included in the workbook.

In Microsoft Excel, the charting concepts are similar, but the interface and menu paths differ. Excel for Microsoft 365 on Windows creates charts from the Insert tab’s chart controls; its chart editor and formatting options are not the Google Sheets Chart editor. Instructions that name Sheets menus such as Insert > Chart therefore apply to Sheets in a web browser, not Excel.

Frequently Asked Questions

How do I make a horizontal bar chart in Google Sheets?
Select the category and value columns, choose Insert > Chart, and select Bar chart under the Chart editor’s Setup tab. The standard bar chart uses horizontal bars.

How do I put the largest bar at the top?
Sort the source data into the order you want, such as largest to smallest, and check how the category order appears in the chart. The chart follows the source arrangement, though the visual top-to-bottom order may not match the table’s first-to-last order. If necessary, review the axis options in Customize for a reverse-order setting.

Can I show values on the bars?
Yes. In the Chart editor, open Customize > Series and turn on Data labels when that option is available for the chart. If labels overlap, make the chart larger, reduce the number of categories, or rely on the value axis instead.

What is the difference between a bar chart and a column chart?
A bar chart displays horizontal bars, with categories on the vertical axis. A column chart displays vertical bars, with categories along the horizontal axis. Use horizontal bars when category names are long or a ranked list is the focus.

Why is my chart showing dates or numbers as categories?
Sheets may have interpreted the selected range differently than intended. In Setup, check the data range, header recognition, and whether rows or columns are being used as series. Ensure that the category labels occupy their own column and the numeric values occupy the adjacent series column.

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.