Excel Bar Graph Creation: Steps, Tips, and Fixes

To create a bar graph in Excel for Microsoft 365 on Windows, select a labeled data range, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel inserts a horizontal chart; you can then add a title, labels, and formatting to make the comparison clear.

What Excel Means by a Bar Graph

In Excel, a bar chart displays values with horizontal bars: categories appear along the vertical axis, and the value scale runs along the horizontal axis. A column chart uses the same basic idea but draws vertical bars. People sometimes use bar graph to mean either chart, but the distinction matters when choosing a chart type in Excel.

Horizontal bars are especially useful when category names are long, when you have many categories, or when the ranking is the main point. For example, a chart of sales by product can show each product name beside its bar without forcing long names into a narrow space. A column chart may be a better fit for a small number of categories or values arranged across time periods.

A bar chart compares values across categories. It is not usually the best choice for showing how parts make up a whole, or for showing a continuous trend over many dates. Those questions may call for a stacked chart or a line chart instead.

Prepare the Data Before Inserting a Chart

Arrange the information in a simple table, with category labels in one column and numeric values in the next. Put a descriptive heading at the top of each column, and avoid blank rows or columns inside the data. For instance, cells A1:B5 could contain Product and Units Sold in the header row, followed by four product names and their sales values in rows 2 through 5.

In that example, select A1:B5 before inserting the chart. Excel uses the first column for category names and the second for bar lengths. If the table includes several numeric columns, such as sales for two years, Excel can plot each numeric column as a separate data series.

Use one row per category and one column per measure.
Keep values numeric. A number stored as text may be ignored or plotted unexpectedly.
Use clear, concise category labels; long labels are one reason to prefer horizontal bars.
Exclude totals if they would distort the comparison. A grand total is usually not another category of the same kind.

If the data is an Excel table, selecting a cell in the table and inserting a chart can make it easier for the chart to include new rows added later. For a regular cell range, the chart uses the range selected at creation; you can adjust it afterward if the source data changes.

Create a Clustered Bar Chart on Windows

Select the table, including its column headings. In the example above, select A1:B5.
Open the Insert tab on the ribbon.
Choose Insert Column or Bar Chart in the Charts group.
Under 2-D Bar, choose Clustered Bar. The chart appears on the worksheet.
Select the chart title and type a specific description, such as Units Sold by Product.

Clustered Bar is the usual starting point when each category has one value or when you want to compare several series side by side. Excel may also offer Recommended Charts, which can suggest a chart based on the selected range. Review the preview and confirm that the categories and series are assigned in the intended direction before accepting it.

On Excel for Mac, the Insert tab also provides chart options, though labels and ribbon layouts can differ slightly by release. Look for the bar chart choices under Insert rather than relying on a Windows-only screen description. Excel for the web also supports inserting charts, but some formatting and chart-management options available in the desktop application may be limited or arranged differently.

Choose the Right Bar Chart Type

Excel offers several bar chart types, and the right one depends on what you want the reader to compare. The basic options are in the Insert Column or Bar Chart menu.

Clustered Bar: Places series side by side for each category. Choose it to compare groups, such as 2025 and 2026 sales for each product.
Stacked Bar: Places series segments end to end. It shows both the combined value and the contribution of each series, although comparing individual segments can be difficult.
100% Stacked Bar: Scales each category to 100 percent. It is useful for comparing proportions, but it hides differences in total size.
3-D Bar: Adds a three-dimensional appearance. Perspective can make bar lengths harder to compare accurately, so a 2-D chart is generally clearer for ordinary reporting.

For a single series of values, a clustered bar chart is typically the clearest option. If the goal is to rank categories, sort the source values before charting or reorder the chart categories afterward. If the goal is to show change over time, consider whether a line chart or column chart communicates the time sequence more naturally.

Improve Labels, Ordering, and Readability

A chart should make the comparison understandable without requiring readers to guess what the bars represent. Select the chart, then use the Chart Design tab to access chart elements and styles. In desktop Excel, a plus-shaped Chart Elements button may also appear beside a selected chart. Available controls can vary depending on the application and chart selection.

Useful improvements often include:

Chart title: State the measure and subject, such as Monthly Orders by Region.
Data labels: Show exact values when readers need them. Select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a position such as Outside End.
Axis titles: Add them when the value scale or categories need explanation, especially when units are not obvious.
Number formatting: Format the value axis with suitable units, such as currency or percentages, rather than displaying unnecessary decimal places.
Color: Use a restrained palette. Highlight a particular category only when that emphasis has a clear meaning.

To change the order, you can sort the source table by the value column. A horizontal bar chart may display the first category at the bottom, depending on its axis settings. To change that display, right-click the category axis, choose Format Axis, and adjust Categories in reverse order if the option is available in the pane. Check the result because reversing categories can also affect where the value axis crosses.

Keep the scale honest. Excel usually sets an axis scale automatically, but a truncated value axis can exaggerate small differences. Right-click the value axis and choose Format Axis to inspect or adjust its bounds. For bar charts that begin at zero, differences in bar length are generally easier to interpret fairly.

Change the Data or Chart Afterward

You do not need to start over to correct a chart. Select it and use Chart Design > Select Data to review the chart data range, add or remove a series, or adjust category labels. This is useful if Excel has treated a heading as a category or included an unwanted column.

If the categories and series are switched, select the chart and choose Chart Design > Switch Row/Column. This changes how Excel interprets rows and columns; it does not rearrange the worksheet data. Check the legend and category axis afterward to confirm that the display now matches the question you are trying to answer.

When you add records, a chart based on a fixed range may not expand automatically. If the source is an Excel table, new rows entered directly below it are generally included in the table, and charts based on the table can reflect the expanded data. Otherwise, use Select Data to update the chart range. This is a practical reason to structure frequently updated source data as a table.

Common Problems and How to Fix Them

The chart shows the wrong categories: Use Chart Design > Select Data to inspect the category labels and series ranges. Confirm that the label column is included.
Excel plots headings as values: Check that the header row is included and that the chart recognizes it as labels. Correct the series name or data range in Select Data if necessary.
Bars are missing: Check whether the source values are numbers, whether filters hide rows, and whether the chart range includes the relevant cells. Text-formatted numbers may need to be converted to numeric values.
There is too much empty space: Review the value-axis bounds and category spacing. Avoid changing the scale in a way that misrepresents differences.
The labels are cramped: Widen the chart, shorten labels in the source data when appropriate, or use a horizontal bar chart rather than a column chart.
New rows do not appear: Update the source range with Select Data, or use a well-structured Excel table as the chart source.

When using filters, remember that chart behavior can depend on the chart’s settings and the worksheet rows being hidden. If the chart should display filtered data only, inspect the chart’s Select Data settings and, where available, its Hidden and Empty Cells options.

Bar Charts Compared With Other Excel Charts

A bar chart is strongest when readers need to compare categories, particularly when category names are long. A column chart is also a category comparison, but its vertical bars can be more familiar for a small set of values or discrete time periods. Neither chart type is automatically more accurate; readability and the data’s structure should guide the choice.

Use a line chart when the order of observations is meaningful and the focus is a continuous trend, such as monthly temperature. Use a pie chart only when there are a few parts of one whole and the proportions are the main message. A stacked bar chart can show composition across categories, while a 100% stacked bar chart compares composition without emphasizing the categories’ total sizes.

A common misconception is that every chart with bars is a bar chart in Excel. In Excel’s chart menu, Bar refers to horizontal bars and Column refers to vertical bars. If a tutorial says to insert a bar graph, check whether it means horizontal bars or uses the phrase loosely for any bar-shaped chart.

Frequently Asked Questions

How do I make a bar graph in Excel with two sets of data?
Select the category column and both numeric columns, including their headings, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel should show the two series side by side for each category. Use Chart Design > Select Data if the series or labels are assigned incorrectly.

How do I show the largest bar at the top?
Sort the source table from largest to smallest, then inspect the category-axis order. If Excel displays the first category at the bottom, right-click the category axis, choose Format Axis, and use Categories in reverse order. Confirm that the value axis remains in a sensible position.

How do I add numbers to the bars?
Select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a placement such as Outside End. If that menu is not convenient in your version, select the chart and use the Chart Elements button when it appears.

Can an Excel bar chart update when I add data?
It can, depending on how the source data is set up. A chart based on an Excel table can generally include rows added to that table. For a chart based on a fixed range, use Chart Design > Select Data to expand the range when you add records.

What is the difference between a bar chart and a column chart?
A bar chart uses horizontal bars, with categories on the vertical axis. A column chart uses vertical bars, with categories along the horizontal axis. Both can compare values across categories; horizontal bars often fit long labels better.

Why does Excel make a chart with the wrong layout?
Excel infers which rows and columns contain labels and series from the selected range. Include clear headings and select only the relevant table. If the interpretation is still wrong, choose Chart Design > Switch Row/Column or correct the ranges in Select Data.

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.