Bar Chart in Excel: How to Create and Format One

To make a bar chart in Excel for Microsoft 365 on Windows, arrange category names in one column and the numbers to compare in the next, select the data including its headings, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel creates a horizontal chart; you can then add a title, labels, and other formatting from the Chart Design and Format tabs.

What a bar chart shows

A bar chart compares values across categories using horizontal bars. The length of each bar represents a number, such as sales, survey responses, or hours worked. Category names appear along the vertical axis, while the value scale runs horizontally. This layout gives long category labels room to fit and makes it easy to compare items when there are several of them.

Excel distinguishes a bar chart from a column chart: bars are horizontal, while columns are vertical. The terms are sometimes used loosely, but the chart choice matters. A horizontal bar chart is often a good fit for product names, departments, or other labels that would be cramped beneath vertical columns. A column chart can be more natural for values over time when the periods are ordered from left to right.

For example, a small table with a Product heading and a Units Sold heading can show one bar for each product. If Product A sold 42 units and Product B sold 28, the first bar will be longer. The chart makes the difference visible without asking the reader to compare each number in a table.

Prepare data that Excel can chart

Excel uses the selected cell range to decide which values are categories and which are data series. For a basic chart, put category labels in the first column, numeric values beside them, and descriptive headings in the first row. Keep the table contiguous: avoid blank rows or columns inside it, merged cells, and notes mixed into the data. Include the headings when selecting the range so Excel can use them as series and axis labels.

Use one row per category, such as one row per product or region.
Use one numeric column for a simple comparison, or additional numeric columns to compare groups.
Check that the values are numbers, not text that only looks like a number. Text values may be omitted or plotted unexpectedly.
Use clear, reasonably short category names. Long labels can still appear, but they may make the chart taller or harder to scan.

Suppose a worksheet contains Department and Expenses headings, followed by department names and their expense totals. Select both headings and all the rows beneath them. If the chart instead shows department names as separate colored bars and expenses as category labels, Excel may have interpreted rows and columns in the opposite direction. Use Chart Design > Switch Row/Column to change that interpretation.

Create a clustered bar chart in Windows

In Excel for Microsoft 365 on Windows, select the data range and use the ribbon path Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. The chart appears on the worksheet, and Excel usually adds contextual Chart Design and Format tabs when the chart is selected. The chart is linked to the source cells, so changing a plotted value normally updates the bar.

Click a cell in the data table and select the full range, including its headings. If Excel has not selected the intended range automatically, drag across the cells or use the Name Box to enter the range.
Open the Insert tab, choose Insert Column or Bar Chart, and select Clustered Bar under 2-D Bar.
Click the chart title and type a specific description, such as “Units Sold by Product.” A useful title tells readers what is being compared, not merely that the graphic is a chart.
Use Chart Design > Add Chart Element to add elements such as axis titles, data labels, or a legend when they help explain the data.
Resize or move the chart by dragging its border. Drag a corner handle to resize while keeping its proportions more consistent.

Excel for Mac has the same general chart types, although ribbon labels and placement can vary by build. A reliable route is to select the data, choose Insert > Recommended Charts, open All Charts, choose Bar, select a subtype, and confirm. In Excel for the web, chart insertion is also available from Insert, but the controls and formatting options can differ from the desktop app.

Choose the right bar chart subtype

Clustered Bar is the usual starting point when categories have one value each, or when you want to compare several series side by side. For instance, columns for 2024 and 2025 can appear as two adjacent bars for each region. This makes direct comparisons possible, but too many series can clutter the chart and make the color legend difficult to follow.

Stacked Bar combines series into a single bar for each category. It shows both the category total and the components that make up that total. It works best when the components are meaningful and the number of series is limited. Because only the first segment in each bar begins at the same baseline, comparing the sizes of middle segments across categories can be difficult.

100% Stacked Bar scales every category to the same total length. It is useful for comparing proportions, such as the percentage of responses in different survey groups, but it hides differences in overall totals. If one department has 20 responses and another has 200, a 100% stacked chart emphasizes the composition rather than the response count.

Use a 3-D bar chart only when its perspective genuinely helps communicate the data; the visual depth can make lengths harder to judge. For most comparisons, a 2-D chart is easier to read. If the goal is to show a trend across many dates, consider whether a line chart or column chart would convey sequence more clearly than a bar chart.

Make the chart easier to read

Formatting should make the comparison clearer, not decorate it at the expense of accuracy. Give the chart a descriptive title, keep category names readable, and use a consistent scale. To add values at the ends of bars, select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a position such as Outside End. Labels are useful when readers need exact values, but they can overlap when the chart contains many categories or the bars are short.

Use a legend when the chart has multiple series and the colors need explanation. With one series, a legend that repeats the series heading may take up space without adding much. Axis titles can clarify units: “Revenue (thousands of dollars)” is more informative than “Revenue” if the plotted figures represent thousands. Avoid removing the value axis or changing its scale in a way that exaggerates small differences.

To alter the order of categories, sort the source table if the order should also change in the worksheet. You can also right-click the category axis, select Format Axis, and use the axis options to reverse category order. In some layouts, reversing categories changes where the value axis crosses the chart, so check the result and adjust the crossing option if needed. Sorting the data from largest to smallest often makes a ranking chart easier to scan.

To change colors or other appearance settings, select the chart and explore Chart Design chart styles or the Format tab. A single highlight color can call attention to a key category, but use color consistently and do not rely on color alone to communicate meaning. Data labels or direct category names can help readers who may not distinguish particular colors.

When to use a bar chart instead of another chart

A bar chart is well suited to comparisons among named categories, especially when category labels are long or the ranking is important. It is less suitable when the main message is a continuous trend over time, a relationship between two numeric variables, or a distribution of many observations. In those cases, a line chart, scatter chart, or histogram may answer the question more directly.

Do not confuse a stacked chart with a chart of independent totals. Stacking adds series together, so it is meaningful only when the series are components of the same total. If “North” and “South” are separate sales figures that should be compared, clustered bars are usually clearer. If each region’s total consists of product categories, stacking those products can show how each regional total is composed.

A chart is not automatically better than a table. A table is more useful when readers need to look up exact numbers across many categories. A chart is useful for spotting relative size, rank, or a broad pattern. Many reports benefit from both: the chart for the visual comparison and the table for precise values.

Common problems and how to fix them

If Excel plots categories as series, or puts the wrong labels on the axis, select the chart and choose Chart Design > Switch Row/Column. This commonly happens when a table has several rows of values or when the selected range is oriented differently from Excel’s guess. Confirm that the intended category names and series headings are visible before adjusting colors or labels.

If bars are missing, check that the cells contain numeric values and that the selected range includes them. A number imported as text may not behave like a number; inspect the cell format and correct the source data where necessary. Also check whether filters or hidden rows are affecting what appears. Chart behavior can depend on the chart’s settings for showing data in hidden rows and columns.

If labels overlap, try a larger chart, a smaller font, fewer displayed labels, or shorter category names in the source. Adding every label to a chart with dozens of categories can make it less readable. If the category list is long, consider charting a focused subset or using a table alongside the chart.

If a bar chart appears to show almost no difference, inspect the value axis. Right-click the value axis and choose Format Axis to review its bounds and units. A scale that starts above zero can make modest differences look dramatic; for ordinary bar comparisons, a zero baseline is generally the clearest and fairest choice because bar length encodes magnitude. If the data include negative values, Excel can display bars extending in opposite directions from zero, which is often useful for showing gains and losses.

To remove a chart, select its outer border and press Delete. If you make an unwanted formatting change, use Ctrl+Z on Windows or Command+Z on Mac to undo it. Undo applies to the most recent action, so it is not a substitute for keeping a copy of important source data.

Frequently Asked Questions

How do I make a bar chart in an Excel sheet?
Select the category labels and values, including their headings, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar in Excel for Microsoft 365 on Windows. Add a useful title and labels if they make the comparison easier to understand.

What is the difference between a bar chart and a column chart in Excel?
A bar chart has horizontal bars, with categories on the vertical axis. A column chart has vertical columns, with categories along the horizontal axis. Both compare values, but horizontal bars usually accommodate long category names better.

How do I put numbers at the end of each bar?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > Outside End. The exact position choices depend on the chart type. If labels crowd one another, enlarge the chart or show fewer labels.

Can I make a bar chart with multiple data series?
Yes. Put each series in its own numeric column and include a heading for each one. A clustered bar chart places the series side by side within each category; a stacked bar chart combines them into one bar when they are parts of a meaningful total.

Why are my bar chart categories in the wrong order?
Sort the source data into the order you want, or right-click the category axis, choose Format Axis, and change the category order setting. Reversing the axis can affect where the value axis appears, so review the full chart after changing it.

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.