Bar Chart Maker in Excel: Create and Format Charts

Excel has a built-in bar chart maker: select your category labels and values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel creates a horizontal bar chart that you can label, sort, format, and update as your data changes.

What Excel means by a bar chart

In Excel, a bar chart displays categories along the vertical axis and values along the horizontal axis. The length of each bar represents its value, making it easy to compare items such as sales by product, responses by survey choice, or expenses by department. This is different from a column chart, which uses vertical bars. Excel groups both chart types under the Insert Column or Bar Chart menu, so check the orientation before choosing.

A clustered bar chart is the usual starting point when you have one value for each category. A stacked bar chart divides each category’s bar into segments to show how component values contribute to a total. A 100% stacked bar chart scales each total to 100%, which helps compare proportions rather than absolute amounts. These options are useful for different questions; a chart that makes component shares clear may make the actual totals harder to compare.

Prepare the data before making the chart

A clean, rectangular data range helps Excel interpret the information correctly. Put category names in one column and the numbers to chart in the next, with a descriptive heading at the top of each column. For example, a small table might have Product in A1, Units Sold in B1, and three product names with their sales figures in rows 2 through 4. Select the headings and data together so Excel can use the headings as the series and axis labels.

Before selecting the range, check that:

Each row represents one category and each column represents one data series.
Values intended for comparison are numeric, not numbers stored as text.
There are no blank rows or columns splitting the table into separate blocks.
Category names are clear and reasonably short. Long labels can fit better on a horizontal bar chart than on a column chart.

You do not need to sort the source table first, but sorting often makes the finished chart easier to read. Avoid including totals in a chart of individual categories unless the total is meant to be compared as another category. Including a total alongside its component values can make the visual comparison misleading because the total is not equivalent to one of the parts.

Create a bar chart in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, follow these steps to insert a standard horizontal chart:

Select the data range, including the column headings.
Open the Insert tab on the ribbon.
Select Insert Column or Bar Chart in the Charts group.
Under 2-D Bar, choose Clustered Bar.
Click the chart title to replace it with a title that describes the measure and categories.

Excel places the chart on the worksheet. Click and drag its border to move it, or drag a corner handle to resize it. If the chart shows categories as separate colored series, or the labels appear in an unexpected direction, select the chart and use Chart Design > Switch Row/Column. This changes how Excel reads rows and columns; it does not rearrange the source cells.

For a stacked chart, select Stacked Bar or 100% Stacked Bar from the same 2-D Bar menu. Excel also offers 3-D chart choices, but three-dimensional effects can make bar lengths and comparisons harder to judge. For ordinary reporting, a two-dimensional chart is generally clearer.

Format the chart so its message is clear

Select the chart to show the Chart Design and Format tabs. Chart Design includes chart styles and commands for adding or changing chart elements. To add labels or axis titles, use Chart Design > Add Chart Element, then choose the element and its placement. Available options depend on the chart type. A useful chart title says what is being compared, while axis titles identify the measure and, where relevant, its units, such as dollars or units sold.

Data labels can display values at the ends of bars, reducing the need to estimate from the axis. Use them when the chart has a manageable number of categories; labels on a crowded chart can overlap. The legend is useful when multiple series appear, but it is unnecessary for a single series. Remove it if it consumes space without explaining anything.

Use color to distinguish meaningful series, not to decorate every bar differently without a reason. Keep text large enough to read at the chart’s final size, and use strong contrast between bars and background. For an accessible chart, do not rely on color alone to communicate a difference; include a legend, labels, or clear category names. A descriptive chart title and alternative text can also help readers using assistive technology.

Sort categories and handle long labels

For a single series, sorting the source values from largest to smallest often makes the ranking immediately visible. Sort the entire table, not only the values column, so each number stays paired with its category. The chart will follow the source order. If a category axis appears to run in the opposite direction from what you expect, right-click the category axis, choose Format Axis, and look for the Categories in reverse order setting. The precise position of axis options can vary with the version and chart selection.

Horizontal bars are especially useful when category names are long because the labels sit beside the bars. If names still crowd the plot, enlarge the chart, shorten labels in the source data without making them ambiguous, or show fewer categories. A chart of every item in a long list may be less useful than a chart of the most relevant items, provided you state clearly how the selection was made.

Choose the right bar chart type

Choose the chart according to the comparison you want readers to make:

Clustered Bar: Compare values across categories, or compare multiple series side by side within each category.
Stacked Bar: Show both the total for each category and how its component series contribute to that total.
100% Stacked Bar: Compare the percentage composition of categories when totals differ. The chart emphasizes shares, not the original totals.

For example, clustered bars can compare quarterly revenue for several regions, with one group of bars per region. Stacked bars can show how product types contribute to each region’s revenue. If the question is whether product mix differs by region, 100% stacked bars may be more suitable. If the question is which region generated the most revenue, the 100% version hides the total-size comparison, so a clustered or ordinary stacked chart may be more appropriate.

When there are many series, clustered bars can become too dense to compare. Consider a simpler chart, fewer series, or separate charts for distinct questions. The goal is not to use every available data point in one graphic; it is to make the important comparison understandable.

Common problems and how to fix them

If Excel creates the wrong arrangement, first check that the selected range includes the intended labels and headings. Then try Chart Design > Switch Row/Column. If the category names appear as a single series name, the range may have been selected in an unexpected shape or may be missing a heading. A simple two-column table with one heading row is a reliable way to start.

If bars are missing or unexpectedly short, inspect the source cells for text-formatted numbers, blank cells, or values much larger than the rest. A single unusually large value can compress all the other bars visually. Confirm that the axis scale is appropriate before changing it: truncating a bar chart’s value axis can exaggerate differences, especially when the chart is intended to compare magnitudes. For straightforward comparisons, an axis beginning at zero is often the clearest choice.

If labels overlap, reduce the number of categories, widen the chart, or simplify the text. If the colors or layout change after updating data, review the series and chart formatting rather than assuming the source values are wrong. Small changes in the selected range can also cause Excel to include an unintended row or omit a new one.

Make the chart update when data changes

A chart linked to worksheet cells normally reflects edits to those cells. However, adding new rows just below a plain selected range may not always add them to the chart’s source. For data that will grow, convert the range into an Excel table: select a cell in the data and choose Insert > Table, confirming that the table has headers if it does. Charts based on table data can include new rows as the table expands, which is useful for recurring reports.

To check or adjust what a chart uses, select it and choose Chart Design > Select Data. The dialog shows the chart data range and the series and category labels Excel has identified. This is also where you can add, remove, or edit a series. Keep the table structure consistent when refreshing a report, so new values remain in the same columns and do not disrupt the chart’s interpretation.

Excel compared with other chart-making options

Excel is a practical bar chart maker when the data already lives in a workbook, when calculations and charts need to stay together, or when you want to adjust the chart directly. It also supports chart formatting, labels, multiple series, and worksheet-linked data without requiring a separate graphics program. For a quick one-off graphic, however, a spreadsheet may be more setup than necessary; a presentation or dedicated visualization tool may suit a different publishing workflow.

Excel for the web also supports creating and editing charts, though the ribbon layout and available formatting controls can differ from the Windows desktop app. Excel for Mac has chart tools too, but the menus and some controls may be arranged differently. The steps above name the Microsoft 365 Windows ribbon paths. If a command is not in the same place on another platform, use the chart-related commands on its Insert or Chart Design tabs rather than assuming the Windows interface is identical.

Frequently Asked Questions

How do I make a bar chart in Excel?
Select the category labels and values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Add a title and, if needed, axis titles or data labels.

What is the difference between a bar chart and a column chart in Excel?
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 are available from Excel’s Insert Column or Bar Chart menu.

How do I put the largest bar at the top?
Sort the source table by its value column from largest to smallest, keeping each category paired with its value. If Excel displays the category order in the opposite direction, use Format Axis and change the category order setting.

Can I make a bar chart with multiple data series?
Yes. Put each series in a separate column with a heading and categories in the first column, then select the complete table and insert a clustered or stacked bar chart. Use Switch Row/Column if Excel groups the data in the wrong direction.

Why are my new rows not showing in the chart?
The chart may refer to a fixed cell range that does not include the added rows. Expand the source range with Chart Design > Select Data, or base the chart on an Excel table that can expand as rows are added.

Can I create a bar chart in Excel without a legend?
Yes. If the chart has only one series, select the legend and press Delete, or use Chart Design > Add Chart Element to manage chart elements. Keep a legend when it is needed to identify multiple series.

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.