Bar Chart Examples in Excel: How to Create and Choose

Useful bar chart examples in Excel include comparing sales by product, survey responses by answer, or monthly results across regions. To make one in Microsoft Excel for Microsoft 365 on Windows, select a category-and-value table, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. The chart displays categories as horizontal bars, making differences easy to compare.

Bar Chart Examples for Common Data

A bar chart works well when each bar represents a named category and its length represents a number. For instance, a shop might compare units sold across products:

Product	Units sold
Notebook	42
Pen set	68
Desk lamp	31
Water bottle	55

Selecting these two columns and inserting a clustered bar chart gives one bar per product. The pen set has the longest bar at 68 units, while the desk lamp has the shortest at 31. This is a straightforward example of using a bar chart to rank items or compare their values.

Other practical examples include:

Survey answers: show how many respondents selected each option, such as very satisfied, satisfied, or dissatisfied.
Department budgets: compare planned spending across departments, provided every value uses the same currency and time period.
Support requests: compare ticket counts by issue type or team.
Regional performance: compare revenue by region for one clearly defined month, quarter, or year.
Project status: show counts of tasks that are complete, in progress, or not started.

In each case, the category labels explain what the bars represent, and the values should measure the same kind of thing. A chart comparing dollars with percentages, for example, would be misleading unless the data is transformed into a meaningful common measure.

When to Choose a Bar Chart

Bar charts are particularly helpful when category names are long. Because the labels sit alongside horizontal bars, names such as “Customer onboarding and training” are easier to read than they would be beneath narrow vertical columns. A bar chart can also make ranking more apparent, especially when the categories are ordered from largest to smallest.

Choose a clustered bar chart when you want to compare one value for each category, or several values side by side within each category. A column chart may be a better fit when time runs along the horizontal axis and the reader should see a sequence such as months or years. Excel’s “bar” chart type means horizontal bars; its “column” chart type means vertical bars. Both compare categories, but their orientation changes how labels and sequences read.

Consider the number of categories before choosing. A chart with a handful of product names is usually clear; one with dozens of labels may become tall and difficult to scan. For a long list, consider showing only a relevant subset, grouping minor categories, or using a table alongside the chart. Avoid removing categories in a way that hides important context.

How to Create a Bar Chart in Excel

Arrange the data in adjacent columns, with category names in the first column and numeric values in the next. Put a descriptive header at the top of each column, and avoid blank rows within the range. For the product example, the headers are Product and Units sold, followed by four product-value pairs.

Select the cells containing both headers and all category-value rows.
On the Windows ribbon, choose Insert > Insert Column or Bar Chart.
Under 2-D Bar, choose Clustered Bar. Excel inserts the chart in the worksheet.
Click the chart title and replace the placeholder with a specific title, such as “Units Sold by Product.”
Review the categories, values, and axis scale to confirm the chart represents the selected data correctly.

Excel usually recognizes the first column as category labels and the second as values. If the chart has interpreted the rows and columns in the wrong direction, select the chart and use Chart Design > Switch Row/Column. For instance, this can help when each column contains a separate series and each row is a category.

On Mac, the same basic workflow applies: select the data, use the Insert tab to choose a bar chart, and edit the chart with the chart-design controls. Ribbon wording and layout can vary slightly by Excel release. Excel for the web also supports inserting charts, although some detailed formatting options may differ from the desktop app.

Clustered, Stacked, and 100% Stacked Bars

Excel offers several bar chart arrangements, and the right one depends on the question the chart should answer.

Clustered Bar: places series next to one another for every category. Use it to compare values such as this year’s and last year’s sales for each product.
Stacked Bar: combines series into a single bar per category. It shows both the total and the parts that make up that total, such as completed and pending requests by team.
100% Stacked Bar: scales each category’s total to 100%, emphasizing the proportion contributed by each series rather than differences in totals.

Suppose a report compares online and in-store sales across four regions. Clustered bars make it easy to compare the two channels within each region. Stacked bars show each region’s combined sales as well as the channel contribution. A 100% stacked chart compares channel shares, but it no longer shows which region sold the greatest total. Choose based on whether the reader needs to compare values, totals, or proportions.

Sort and Prepare the Data

For a ranking chart, sort the source table by the value column so the bars follow a deliberate order. Select the table, then use Data > Sort and sort by the numeric field from largest to smallest. Excel bar charts often place the first category at the bottom of the plot, so a descending source order may appear bottom-to-top. If you want the largest bar at the top, select the category axis, open Format Axis, and adjust the category order setting where available. Check the result rather than assuming the visual order matches the worksheet.

Keep the source data clean before charting. Each row should represent one category, and each series should have its own column with a clear heading. Store values as numbers rather than text that merely looks numeric. For example, a value entered as “42 units” may not behave like the number 42. Handle missing values consistently: a blank may appear as no bar, while entering zero explicitly communicates a measured value of zero. These meanings are not interchangeable.

Format Labels, Axes, and Colors

Formatting should make the comparison clearer, not decorate the chart for its own sake. Select the chart and use Chart Design > Add Chart Element to add a title, axis titles, data labels, or gridlines. A value axis title such as “Units sold” helps readers understand the scale. Data labels can make exact values visible without forcing readers to estimate bar lengths, but too many labels can clutter a chart.

Use a consistent, limited color scheme. One color is often enough for a single data series. In a clustered or stacked chart, use distinct colors for the series and keep the same series color consistent across categories. Do not rely on color alone to communicate meaning; labels and a legend also help people who cannot distinguish particular colors.

Bar charts commonly use a value axis that begins at zero. Since bar length encodes magnitude, truncating that axis can exaggerate small differences. If the scale is changed, make the choice explicit and consider whether a different chart type would communicate the comparison more honestly. For large values, number formatting such as thousands or millions can reduce visual clutter while preserving the underlying data.

Common Bar Chart Problems

If Excel creates an unexpected chart, first check the selected range. Extra blank columns, unrelated totals, or a title row included in the wrong place can cause Excel to plot the wrong series. Confirm that category labels and values are adjacent, then use Chart Design > Select Data to inspect or change the chart’s data range.

Bars appear for the wrong categories: check whether row and column orientation should be switched.
Labels are cut off: widen the chart, reduce label length, or use a horizontal bar chart for long names.
Bars look nearly identical: check the number format and value scale, and consider adding data labels.
The chart is crowded: reduce the number of categories or split separate questions into separate charts.
A zero is missing or looks like a blank: inspect the source cells and decide whether the value is truly zero or unknown.

A related misconception is that every bar chart should be sorted from highest to lowest. That ordering is useful for rankings, but it is not always appropriate. If categories have a meaningful order—such as low, medium, and high satisfaction—preserve that order. If they represent months, keep them chronological rather than sorting by value.

Make the Chart Easier to Read and Share

Use a title that names the measure and scope, not a vague label such as “Results.” Include the period or unit when it matters, for example, “Support Tickets by Issue Type, October.” Make sure the chart remains understandable if it is copied into a presentation without the worksheet around it. A brief note can explain exclusions, unusual definitions, or whether the values are counts, percentages, or estimates.

Before sharing, check that labels are readable at the size at which the chart will be viewed. Use a meaningful chart title and avoid overly small text. If the workbook is shared with others, keep the source data accessible and clearly labeled so they can verify or update the chart. A bar chart summarizes information; it should not conceal the numbers or definitions needed to interpret that summary.

Frequently Asked Questions

How do I make a bar chart in Excel?
Select the category and value columns, including their headers, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Add a useful title and check that Excel assigned the labels and values correctly.

What is the difference between a bar chart and a column chart in Excel?
A bar chart uses horizontal bars, while a column chart uses vertical bars. Both compare values by category. Horizontal bars are often easier to read when category names are long.

How do I show values on the bars?
Select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a label position. The exact options can depend on the selected chart type and Excel version.

Can I make a bar chart with multiple data series?
Yes. Arrange each series in a separate column beside the category column, select the full table, and insert a clustered, stacked, or 100% stacked bar chart. Use clustered bars for side-by-side value comparisons and stacked bars for composition.

Why are my bar chart categories in the wrong order?
Check the source-table order and the category-axis settings. Sorting the data changes its order, while formatting the category axis can reverse how categories appear in the chart. Preserve a natural sequence when categories have a meaningful order.

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.