Excel Bar Plot: How to Create and Format One

In Excel for Microsoft 365 on Windows, select your category and value columns, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Excel calls this a bar chart: its bars run horizontally, while a column chart uses vertical bars.

What Excel Means by a Bar Plot

“Bar plot” is a general name for a chart that compares values using rectangular bars. In Excel’s chart menu, the corresponding chart family is called Bar. A standard bar chart places categories along the vertical axis and numeric values along the horizontal axis. It is useful for comparing items such as sales by product, survey responses by answer, or expenses by department.

The horizontal layout is especially helpful when category names are long. A label such as “Customer support and training” has more room beside a horizontal bar than beneath a narrow vertical column. Bar charts can also make differences between a small number of values easy to scan, provided the scale and labels are clear.

Excel’s standard bar chart is not the same as a histogram. A bar chart compares separate categories; a histogram groups numerical observations into ranges, such as ages from 20 to 29 or 30 to 39. The bars in a bar chart may have spaces between them, while a histogram’s adjoining bins are generally shown without gaps. Choosing the right chart depends on what the data represents, not just on the appearance you want.

Prepare the Data Before Charting

Arrange the source data in a simple rectangular range. Put category names in the first column, one numeric measure in the next column, and clear headings in the first row. For example, a worksheet might list Product and Units Sold as headings, then show a product name and its sales total on each row. This layout helps Excel identify which cells are labels and which contain values.

Before inserting a chart, check that the values are genuinely numeric. Numbers stored as text may be treated unexpectedly, and blank cells can leave gaps or make a chart harder to interpret. Remove unnecessary total rows if they would be misleading as another category. If you want to compare several measures, place each measure in a separate column with its own heading; Excel can then use each column as a data series.

For data that will grow over time, consider converting the range to an Excel table using Insert > Table. Tables provide a structured source for the chart and can make it easier to include new rows as the data expands. Confirm that the option indicating the table has headers is selected when your first row contains headings. Keep the source range tidy: explanatory notes or blank columns inside it can cause Excel to include unintended data.

Create a Basic Bar Chart

Select the category labels, numeric values, and their headings. If the columns are adjacent, drag across the full range. If they are separated, select the first range, then hold Ctrl on Windows while selecting the other range.
Open the Insert tab and choose Insert Column or Bar Chart in the Charts group.
Under 2-D Bar, choose Clustered Bar for a straightforward comparison. Excel inserts the chart into the worksheet.
Click the chart title and type a title that explains what is being measured. For example, “Units Sold by Product” is clearer than “Sales.”

Excel generally interprets the first column as categories and each additional numeric column as a separate series. If the chart places the wrong items in the legend or along the category axis, select the chart and use Chart Design > Switch Row/Column. This changes how Excel groups the selected data; it does not change the worksheet values. For example, it can switch between showing each product as a category and showing each month as a series, or the reverse.

On Excel for Mac, the same basic chart types are available from the Insert tab’s chart controls, though the ribbon layout can vary by release. If a command is not immediately visible, look in the Charts group or use Excel’s command search. The instructions above describe Microsoft 365 for Windows.

Choose the Right Bar Chart Type

Clustered Bar is the usual starting point when you need to compare categories or place several series side by side. If your table has a row for each region and separate columns for two years, a clustered chart displays the two year values next to each other for every region. That makes direct comparisons easier, although many series can make the chart crowded.

Stacked Bar places series segments within a single bar for each category. It can show both a total and the parts that make up that total, such as the number of orders from three sales channels in each region. The segments are harder to compare across categories when they do not begin at the same baseline. Use it when composition and totals matter more than precise comparison of every segment.

100% Stacked Bar scales each category to the same full length. It emphasizes proportions rather than absolute totals. For example, it can compare the share of survey answers that are positive, neutral, or negative across departments. It does not show that one department received far more responses than another, so include totals elsewhere if sample size matters.

Excel also offers 3-D bar variations, but perspective can make lengths and values more difficult to judge. For most business and research comparisons, a 2-D chart is easier to read. Choose a type based on the question: compare values with clustered bars, show totals and components with stacked bars, or compare composition with 100% stacked bars.

Format the Chart for Readability

Click the chart to reveal the Chart Design and Format tabs. Chart Design > Add Chart Element provides controls for titles, axis titles, data labels, gridlines, and the legend. A chart does not need every possible element. Add only the information a reader needs to understand the comparison.

For a simple chart, use a descriptive title and retain a numeric value axis. If the units are not obvious, add an axis title such as “Units sold” or “Revenue ($).” Use data labels when readers need exact values, but consider leaving them off when many categories would cause labels to overlap. For a small set of values, Chart Design > Add Chart Element > Data Labels > Outside End places labels at the ends of the bars.

Use color purposefully. A single color is often sufficient when all bars represent the same measure. Distinct colors can help distinguish a small number of series, but too many colors create visual noise. If the colors carry meaning, explain them in the legend or in a note. Avoid relying on color alone when the chart must remain understandable to readers who may not distinguish those colors easily.

Gridlines can help readers estimate values, but heavy or numerous gridlines compete with the bars. Keep a useful value scale and avoid decorative effects that obscure bar lengths. You can resize the chart by dragging its handles, or move it by dragging its border. To make the chart a separate sheet, use Chart Design > Move Chart and choose New sheet.

Sort Categories and Add Useful Labels

Bars are often easier to compare when categories appear in a deliberate order. You can sort the source table by its value column using the Data tab’s Sort controls, or choose a meaningful order such as month, stage, or rating. Sorting alphabetically is appropriate for names, but may not help readers see the largest or smallest values quickly.

Because bar-chart categories are on a vertical axis, Excel’s display order may look reversed from the order in the worksheet. If you want the largest category at the top, select the category axis, open Format Axis, and under Axis Options select Categories in reverse order. Check where the value axis and labels move afterward; axis crossing and label placement can change with the category order. The goal is a readable order, not simply matching the worksheet from top to bottom.

Long names can be wrapped in worksheet cells, but the chart may still need more width to show them comfortably. Enlarge the chart, reduce unnecessary legend space, or shorten labels in a separate display column while preserving the original names elsewhere. If the chart compares multiple measures, use series names that are concise and explicit so the legend is meaningful.

Common Problems and Fixes

The chart shows the wrong orientation. Use Chart Design > Switch Row/Column to change how Excel interprets rows and columns. If you intended horizontal bars but inserted columns, select a Bar chart type from Change Chart Type.
Some categories or values are missing. Select the chart and use Chart Design > Select Data to inspect the chart data range and series. Check whether the intended cells were included and whether values are stored as numbers.
The category order looks backward. Open Format Axis for the category axis and adjust Categories in reverse order. Then review the value-axis position and labels.
The chart is cluttered. Reduce the number of series, remove unnecessary labels or gridlines, or split the comparison into more than one chart. A chart with many bars or series can be technically correct but difficult to interpret.
New rows do not appear. Check the chart’s source range in Chart Design > Select Data. If the dataset is expected to grow, an Excel table can help the chart include added rows, but verify that the chart range updates as intended.

A zero baseline is generally important for bar charts because viewers judge values by bar length. If the axis starts above zero, small differences can look much larger than they are. For values that cannot be negative, retain a zero minimum unless there is a clear reason to do otherwise and the scale is made unmistakable.

Bar Charts Compared With Other Excel Charts

A column chart is the vertical counterpart to a bar chart. Either can compare categories, but horizontal bars usually accommodate long labels better, while columns can work naturally for a short time sequence or categories with brief names. A line chart is generally more appropriate for showing a continuous trend over time, where the sequence between observations matters. A bar chart instead emphasizes comparisons among distinct categories.

For a distribution of individual numeric observations, use a histogram rather than treating each number as a separate category. For a relationship between two numeric variables, a scatter chart is usually more suitable because it plots paired values on two numeric axes. These chart types answer different questions; changing colors or orientation cannot make one type communicate the same information as another.

Frequently Asked Questions

How do I make a bar plot in Excel?
Select category labels and values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar. Add a clear title and check that the categories and series are arranged correctly.

Is a bar chart the same as a column chart in Excel?
They are related chart types, but Excel uses Bar for horizontal bars and Column for vertical bars. Both can compare categories; the best choice depends on label length and the layout that makes the data easiest to read.

How do I put the largest bar at the top?
Sort the source data by its values, then select the chart’s category axis and choose Format Axis > Axis Options > Categories in reverse order if necessary. Check the resulting axis and label positions.

How do I show values on the bars?
Select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a position such as Outside End. If labels overlap, remove them or use a larger chart rather than forcing every value into a crowded view.

Can an Excel bar chart show negative values?
Yes. Negative bars extend in the opposite direction from the zero point on the value axis. Make sure the axis includes zero and that the chart clearly distinguishes negative values from positive ones.

What is the difference between a bar chart and a histogram?
A bar chart compares named categories, such as products or departments. A histogram groups numeric observations into ranges and shows how many observations fall in each range.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.