How to Insert a Bar Graph in Excel: A Step-by-Step Guide

To insert a bar graph in Excel, select your category labels and values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel creates a horizontal chart you can title, label, and format. A bar graph is useful for comparing values across categories, especially when category names are long or you want readers to compare amounts at a glance.

What You’ll Need

An Excel workbook in Microsoft Excel for Microsoft 365 on Windows. The steps below also note where Excel for Mac and Excel for the web may differ.
A small, organized data table with one column for category names and one column for the values you want to compare.
Descriptive column headings, such as Product and Units Sold, so Excel can identify the data series and you can tell what the chart represents.

You do not need to calculate anything extra to make a basic chart. Check that the values are numeric, categories are clearly named, and the table does not include unrelated notes or totals that could distort the comparison.

Step-by-Step

Arrange the data in two columns. Put the categories in the first column and the numbers to compare in the next column. For example, A1 might contain Product, B1 might contain Units Sold, and rows 2 through 5 could list four products and their sales. Use one row per category, keep the headings in the first row, and avoid blank rows within the data. A simple, continuous table makes it easier for Excel to interpret the selection correctly.
Select the data, including its headings. Click the first heading cell and drag through the last value cell. In the example, select A1:B5. Including the headings helps Excel use them as the chart’s series name and category context rather than treating them as data. If your table has more columns, select only the category column and the value column you intend to chart. Extra fields such as dates, notes, or targets may be interpreted as additional series.
Open the bar chart choices. On the Windows ribbon, click Insert, then click Insert Column or Bar Chart in the Charts group. In the menu, look under 2-D Bar and choose Clustered Bar. This creates horizontal bars, with categories listed vertically and values along the horizontal axis. Avoid the similarly named column chart if you specifically need horizontal bars: column charts display vertical bars.
Choose a different bar layout only if it fits your data. The chart menu also offers stacked and 100% stacked bars. A stacked bar combines multiple series within each category, which can help show how parts contribute to a total. A 100% stacked bar compares proportions rather than raw totals. For one value per category, Clustered Bar is usually the clearest starting point. Three-dimensional styles can make lengths harder to compare, so a 2-D chart is generally easier to read.
Check that Excel assigned the data correctly. The category names should appear beside the bars, and the numeric values should determine their lengths. If Excel instead makes the headings into bars or shows categories as separate colored series, click the chart and choose Chart Design > Switch Row/Column. If the chart still looks wrong, choose Chart Design > Select Data and check the chart data range, series name, and category labels.
Move and resize the chart. Click the chart’s outer border and drag it to a clear area of the worksheet. Drag a corner sizing handle to make it larger or smaller while preserving its proportions. Leave room for the category names, title, and any legend. If names are cut off, make the chart wider or adjust the plot area rather than shrinking the text until it becomes difficult to read.
Add a specific chart title. Select the chart, then choose Chart Design > Add Chart Element > Chart Title and select an available placement, such as Above Chart. Click the title placeholder and type a concise description that explains what is being compared, including a useful time period or unit when needed. A title such as “Units Sold by Product, Q1” is more informative than “Sales.”
Add axis titles or data labels when they improve clarity. For axis titles, use Chart Design > Add Chart Element > Axis Titles, then select the horizontal or vertical axis title and enter its meaning. The horizontal axis normally represents a number, such as dollars or units; the vertical axis lists categories. To show values at the ends of bars, choose Chart Design > Add Chart Element > Data Labels and select a placement such as Outside End. Labels are helpful when readers need exact values, but can clutter a chart with many categories.
Format the chart for easy comparison. Click a bar or chart element to select it, then use the contextual Format tab or right-click and choose the relevant formatting option. Keep the bars a consistent color unless color conveys meaningful groups. Use a restrained style, readable text, and an appropriate number format on the value axis. Avoid decorative effects that distract from the differences in bar length.
Review the result against the source table. Confirm that every intended category appears once, the values are represented accurately, and the title and units are clear. If the chart needs to update as you add records, consider converting the source range to an Excel table: select a cell in the data and choose Insert > Table, confirm the range and whether it has headers, then create or reconnect the chart to that table. Save the workbook after checking the finished chart.

On Excel for Mac: The ribbon approach is similar: select the range, open Insert, and choose a bar chart from the chart options. Ribbon grouping and labels can vary slightly by release, so look for the Bar chart option rather than Column if you want horizontal bars. Control-click or right-click a chart element to access its formatting choices. The Windows Alt-key ribbon sequences are not the same on Mac.

In Excel for the web: Select the range, open Insert, and choose the bar chart option from the chart controls. The available chart formatting controls may be more limited or arranged differently from the desktop app. If a particular layout or formatting control is unavailable, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the change there.

Common Mistakes

Choosing a column chart by accident. Bar charts use horizontal bars; column charts use vertical bars. Both can compare categories, but the orientation matters. In the Insert chart gallery, choose an option under 2-D Bar for a horizontal graph.
Selecting totals or unrelated columns. Including a grand total as another category can make the other bars look tiny. Selecting a notes column or a second numeric field can create an unintended series. Select only the labels and values needed for the comparison.
Leaving headings out of the selection. Without headers, Excel may label a series generically, such as Series1, and may not infer the intended category names. Include the header row where possible, then verify the legend and labels.
Using text that looks like numbers. Values imported with leading apostrophes, spaces, or inconsistent separators may be stored as text. Excel might omit them or plot them incorrectly. Check that the cells are recognized as numbers and use a consistent number format.
Adding too many labels or series. Data labels on every bar can overlap in a dense chart, while many colored series can make a comparison hard to follow. Start with one series and add only the labels or groupings readers need.
Using color as the only explanation. A legend with several colors may be hard to interpret, particularly when categories are numerous. Use clear titles, direct labels where practical, and a limited color palette rather than relying on subtle color differences.

Tips

Sort categories to tell a clearer story. Sorting the source values from largest to smallest often makes rankings easier to scan. Sort the entire data range together so labels stay matched with their values. If you want a particular logical order, such as months or steps in a process, preserve that order instead.
Use horizontal bars for long category names. A bar chart gives labels more horizontal room than a column chart’s angled or crowded category axis. If names still do not fit, widen the chart, shorten the displayed labels without losing their meaning, or reduce the number of categories shown.
Choose a sensible value-axis scale. For ordinary bar charts comparing magnitudes, starting the axis at zero makes differences in bar length easier to interpret fairly. To review the scale, right-click the horizontal value axis, select Format Axis, and inspect the Bounds settings. Do not change the scale merely to exaggerate small differences.
Use a legend only when it answers a question. If the chart has one series, the legend often repeats information already in the title or axis. Select the legend and press Delete to remove it. For multiple series, keep a concise legend and explain what each series represents.
Keep the chart connected to the right data. When the source range changes, select the chart and open Chart Design > Select Data to inspect or adjust the range. An Excel table can help include newly added rows, but verify the chart after adding data, especially if the workbook has filters or multiple tables.

Troubleshooting

The chart is blank or some bars are missing. Check that the selected range contains numeric values rather than text, and that the cells are not empty or returning empty text. Also confirm that the chart data range includes the missing rows. If the values were imported, try converting them to numbers using Excel’s available text-to-columns or error-checking options, then review the chart again.
The category names appear as a bar or the orientation is unexpected. Select the chart and choose Chart Design > Switch Row/Column. If that does not fix it, open Select Data and check that the category axis label range points to the cells with names and the series values point to the numeric cells.
The bars are all the same color or the legend is confusing. With one series, a uniform color is normal. If you expected several series, verify that the source data is arranged with categories and series in a consistent table, then use Switch Row/Column if appropriate. For a one-series chart, remove a redundant legend or add data labels instead.
Labels or the title are cut off. Enlarge the chart by dragging a corner, or make more room for the plot area. You can also reduce unnecessary words in the title or choose fewer data labels. If category names are very long, give the chart more width and check the font size before rotating or abbreviating labels.
The chart does not include newly added rows. Click the chart and open Chart Design > Select Data to see whether its range ends before the new records. Extend the range to include them, or use a well-formed Excel table as the data source so added rows are more likely to be incorporated automatically.
The chart compares values misleadingly. Check for a nonzero axis minimum, an accidental total, or a mismatch in units. Right-click the value axis and use Format Axis to review its bounds and number format. Confirm that all compared values use the same units and that the title accurately describes the data.

Frequently Asked Questions

What is the difference between a bar chart and a column chart in Excel?

A bar chart displays horizontal bars, with categories on the vertical axis and values on the horizontal axis. A column chart displays vertical bars. Both can compare categories; horizontal bars are often easier to read when category names are long.

How do I make a bar graph with more than one data series?

Arrange each category in a row and put each series in its own headed column, then select the whole table and insert a Clustered Bar chart. Excel can show a separate bar for each series within each category. Use a stacked option when you specifically want to show combined totals or proportions.

Can I change a column chart into a bar chart after inserting it?

Yes. Select the chart and use Chart Design > Change Chart Type, then choose a bar chart layout. The chart uses the same source data, but its bars become horizontal. If that command is presented differently in your Excel edition, select the chart and look for Change Chart Type on the chart design controls.

How do I show the exact value on each bar?

Select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position. If the labels show too many decimal places, right-click a label, choose Format Data Labels, and adjust the number format.

How can I make the bar graph update when I change a value?

A chart linked to worksheet cells normally updates when those cell values change. If it does not, check that the chart references the cells you edited through Chart Design > Select Data. To include new records more conveniently, format the source range as an Excel table and verify that the chart uses that table.

Can I make a bar graph from non-adjacent columns?

Yes, but it is usually simpler to place the categories and values next to each other in a small helper range and chart that range. You can select non-adjacent cells by holding Ctrl while selecting on Windows or Command on Mac, but the chart may need extra adjustments to assign labels and values correctly.

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.