Excel Bar Chart Tutorial: Create and Format One

To make a bar chart in Excel for Microsoft 365 on Windows, place category names in one column and their values in the next, select both columns, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Add a descriptive chart title, and use the chart’s formatting options to sort, label, and clarify the results.

Make a basic bar chart

A bar chart displays categories along the vertical axis and values as horizontal bars. It is useful when you want to compare amounts across named groups, especially when category labels are long. Start with a simple two-column table: put a heading such as Product in A1, Sales in B1, category names below the first heading, and numbers below the second. For example, a small shop might list Notebooks, Pens, and Folders in A2:A4, with sales of 120, 210, and 85 in B2:B4.

Arrange the data in adjacent columns and include a heading for each column.
Select the headings and all the category and value cells, such as A1:B4 in the example.
On the ribbon, choose Insert > Insert Column or Bar Chart.
Under 2-D Bar, choose Clustered Bar.
Click the chart title and replace the placeholder with a title that tells readers what is being compared.

Excel creates an embedded chart on the worksheet. It uses the selected categories as bar labels and the adjacent numbers as bar lengths. If the chart shows categories as separate series, or treats a heading as a category, check that the selection includes the intended columns and header row. On a Mac, use the Insert tab and the bar-chart option; the button layout and wording can vary by Excel release. Excel for the web can create and edit common charts, though some formatting controls may be more limited than in the desktop app.

Prepare the data before charting

Clean, consistent source data is often more important than decorative formatting. Keep one category per row and one numeric measure per value column. Use clear column headings, avoid blank rows inside the table, and make sure values are stored as numbers rather than text. A cell that looks like 120 but is stored as text may not behave as expected in a chart. If categories repeat, Excel may show them as separate entries; summarize the data first if you intend to compare totals by unique category.

For a chart with several series, use one category column followed by one column for each series. For example, a table could have Month, Online, and In-store headings, with each month on its own row. Selecting the whole table and inserting a clustered bar chart compares the two series within each month. If the source range is likely to grow, consider turning it into an Excel table with Insert > Table before creating the chart. Charts based on a table can include newly added rows as the table expands, although it is still worth checking the chart range if a new field or layout is introduced.

Choose the right bar chart type

Excel offers several bar-chart arrangements, and the best choice depends on the question your chart answers. A clustered bar chart puts series side by side within each category. It works well for direct comparisons, such as sales for two years across several products. A stacked bar chart combines series into one bar per category so readers can see both the total and each series’ contribution. A 100% stacked bar chart scales every bar to the same length, emphasizing proportions rather than absolute totals.

Clustered Bar: Compare the values of separate series within each category.
Stacked Bar: Show how series contribute to each category’s total while retaining the totals’ different sizes.
100% Stacked Bar: Compare the composition or percentage shares of categories, not their absolute totals.

For a single series of values, a clustered bar chart is usually the clearest starting point. Avoid using a stacked chart when the main task is to compare individual series values: only the first series shares a common baseline, so the other segments are harder to compare accurately. If you have many series or very long labels, simplify the data or consider whether a different chart would communicate the point more clearly.

Format the chart for easy reading

Click the chart to show the Chart Design and Format tabs. To add a title through the ribbon, choose Chart Design > Add Chart Element > Chart Title, then select a position such as Above Chart. A useful title names the measure and, where relevant, the period or unit—for example, Monthly orders by product, Q1. Avoid titles that only repeat the worksheet heading or leave the reader to guess what the numbers represent.

Axis titles can explain units when the axis labels alone are not enough. Use Chart Design > Add Chart Element > Axis Titles, then select the relevant axis title and type a label such as Units sold. For exact amounts, make the units explicit in the title or axis label, such as Revenue, thousands of dollars. Number formatting on the horizontal value axis can also reduce clutter: right-click the axis, choose Format Axis, and adjust the number format in the pane. Use a scale that makes differences understandable; a truncated value axis can exaggerate small differences, so consider whether the axis should begin at zero.

Data labels can show values directly on bars. Choose Chart Design > Add Chart Element > Data Labels and select a suitable position, such as Outside End. Labels are helpful for a small number of bars or when readers need exact values, but can make a crowded chart harder to scan. You can remove gridlines or lighten them if they compete with the data, and use a restrained color palette to distinguish series. Keep decorative effects secondary to the comparison the chart is meant to show.

Sort categories and control their order

Excel generally plots categories in the order they appear in the worksheet, but the visual order in a horizontal bar chart can seem upside down: the first row may appear at the bottom. This is a chart-axis display behavior, not a reversal of the underlying data. To change it, right-click the category axis, choose Format Axis, and under Axis Options select Categories in reverse order. Check the value-axis placement afterward, because reversing the category order can also change where the horizontal axis appears.

If the point is to rank categories, sort the source data rather than relying on the chart to create a ranking. Select a cell in the table and use Data > Sort, choosing the value column and Largest to Smallest or Smallest to Largest. Sorting the source keeps the table and chart in the same order and makes the ranking transparent. For example, sorting product sales from largest to smallest makes the strongest result easy to spot. If the source is a table with several related columns, sort the entire table so category names remain paired with their correct values.

Compare series and edit the chart data

When the bars do not match the intended comparison, inspect how Excel has assigned rows and columns. Select the chart and choose Chart Design > Switch Row/Column to change whether rows or columns are treated as series. This is useful when a chart shows one bar per month but you expected one group of bars per product. The command changes the chart’s interpretation of the same selected range; it does not rearrange or rewrite the worksheet data.

To change which cells feed the chart, select it and choose Chart Design > Select Data. In the Select Data Source dialog, you can adjust the chart data range, edit a series, or change the category labels. This is more reliable than rebuilding a chart when you simply need to include another row or correct a range. If a series name appears as Series 1, check whether its column heading was included in the selection. If the source uses filtered or hidden rows, review the chart’s hidden and empty cell settings in the Select Data Source dialog when the displayed results do not match expectations.

Fix common bar-chart problems

The chart is blank or a bar is missing: Check that the value cells contain numeric values and that the chart data range includes them. A number stored as text may need to be converted to a number.
Categories or series are the wrong way around: Select the chart and choose Chart Design > Switch Row/Column, then confirm whether each row or column should represent a series.
The first category appears at the bottom: Use Format Axis > Axis Options > Categories in reverse order, and inspect the position of the value axis afterward.
Labels overlap or are unreadable: Widen the chart, reduce the number of categories shown, shorten source labels, or remove unnecessary data labels. A bar chart is often preferable to a column chart when labels are lengthy.
Differences look misleading: Check the value-axis bounds and number format. A scale that does not start at zero can make differences between bars look much larger than they are.

Also verify that the selected range does not include unrelated totals or notes. Including a grand total as if it were another category can dominate the chart and hide meaningful differences. For a chart intended for a report, check its appearance at the final size: a chart that looks clear when enlarged may be difficult to read when pasted into a document or shown on a slide.

Bar charts versus column charts

Bar and column charts both use rectangular bars to compare values; the main difference is orientation. In Excel’s terminology, a bar chart is horizontal, while a column chart is vertical. A horizontal bar chart is often easier to read with many categories or lengthy names because the labels have more room. A column chart can suit a small number of short categories, particularly when the categories follow a natural sequence such as months.

Neither orientation is automatically more accurate. Choose the one that makes category names, units, and comparisons easiest to understand. If values are measured over time, a line chart may better emphasize a continuous trend, while bars can be effective for discrete periods or a small number of comparisons. The chart should match the data and the question, not simply the visual style you prefer.

Frequently Asked Questions

How do I add numbers to bars in Excel?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position. For a small chart, Outside End often makes values easy to read. If labels overlap, remove some labels or enlarge the chart.

How do I make a bar chart start with the largest value?
Sort the source table by its value column using Data > Sort and choose Largest to Smallest. If the displayed category order still looks reversed, right-click the category axis, open Format Axis, and adjust Categories in reverse order.

Can I make a bar chart with two data series?
Yes. Put categories in the first column and each series in its own column, include the headings, select the full range, and insert a Clustered Bar chart. Use a stacked option only when showing combined totals or proportions is more important than comparing each series directly.

Why does Excel put my first category at the bottom?
Horizontal bar charts display categories on a vertical axis, and Excel’s default axis order can put the first worksheet category at the bottom. Change Categories in reverse order in the category axis’ Format Axis pane to display the order you want.

Can I create a bar chart in Excel for the web?
Yes. Select the data and use the Insert tab’s chart options to create a bar chart. The web version supports common chart tasks, but some detailed formatting and chart controls may differ from or be less extensive than Excel for Microsoft 365 on Windows.

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.