How to Make a Bar Graph in Excel: Column, Bar, Clustered and Stacked Charts

shape
shape
shape
shape
shape
shape
shape
shape
How to Make a Bar Graph in Excel: Column, Bar, Clustered and Stacked Charts - featured image

A bar graph uses rectangles to compare values across categories, such as sales by region, scores by student or costs by department. The length of each bar shows the value, so the reader can compare the categories at a glance. In Excel, vertical bars are called column charts and horizontal bars are called bar charts, but both are commonly called bar graphs. This guide shows how to prepare the data, insert a clustered chart, switch between vertical and horizontal bars, sort the bars, add titles and labels, change colors and spacing, compare two years with clustered bars, show parts of a whole with stacked bars, and fix common problems. A small regional sales example with numbers you can check is used throughout.

Updated November 2026

In this guide

  1. When to use a bar graph
  2. Example data
  3. Step 1: prepare the data
  4. Step 2: insert the chart
  5. Step 3: sort the bars
  6. Step 4: add a title and axis titles
  7. Step 5: show values on the bars
  8. Step 6: change colors and spacing
  9. Step 7: compare two years with clustered bars
  10. Step 8: stacked bars for parts of a whole
  11. Add a target or average line
  12. Fix common problems
  13. Common mistakes
  14. Practice problems
  15. Quick recap

When to use a bar graph

Use a bar graph to compare separate categories, such as regions, products or departments. Use a line graph for change over time, as in our line graph guide, and a pie chart for a few parts of one whole. Bars work well because people compare lengths easily. Use horizontal bars when the category names are long, since the labels have more room. Use vertical columns when the categories are in a natural order, such as months or age groups.

Example data

Create a table with the headers Region, 2025 and 2026 in A1:C1. The regions in A2:A5 are North, South, East and West. The sales for 2025 are 400, 280, 350 and 200, and for 2026 they are 450, 300, 380 and 220. The total for 2025 is 1,230 and the total for 2026 is 1,350. The growth from one year to the next is 120, which is 9.76 percent, since 120 divided by 1,230 is 0.0976. We will start with 2026 alone.

Step 1: prepare the data

Arrange the categories in the first column and the values in the next columns, with a header over each column. Remove empty rows and do not include a total row in the chart selection, or the total will appear as the largest bar. Make sure the values are numbers. If you expect to add rows later, make the range a table with Ctrl+T, so the chart updates automatically. Our table guide explains this in detail.

Step 2: insert the chart

Select A1:A5 and C1:C5, which are the regions and the 2026 sales. Hold Ctrl to select two separate ranges. Go to the Insert tab and open the Column or Bar chart menu in the Charts group. Choose Clustered Column for vertical bars, or Clustered Bar for horizontal bars. Excel inserts the chart with a title, axes and gridlines. The North bar is the tallest, at 450, and the West bar is the shortest, at 220. Drag the chart to the position you want and resize it with the handles.

Step 3: sort the bars

Bars are easier to read when they are sorted from the largest to the smallest, unless the categories have a natural order. Sort the data in the sheet, using Data, Sort, with the sales column from largest to smallest. The chart follows the order of the data. For horizontal bars, Excel draws the first row at the bottom, so the largest value appears at the bottom. To fix it, double-click the vertical axis and tick Categories in reverse order. Our sorting guide shows the steps for sorting.

Step 4: add a title and axis titles

Click the chart and use the plus icon, Chart Elements, to tick Chart Title and Axis Titles. Type a title that says what the chart shows, such as Sales by region, 2026. Add a title to the value axis with the unit, such as Sales in thousands. Clear titles help readers who see the chart without your explanation. If the chart is in a report that already has a heading, you can shorten the title, but the unit should stay visible.

Step 5: show values on the bars

Data labels show the number on each bar, which makes the exact values clear. In Chart Elements, tick Data Labels and choose Outside End. Then the axis and the gridlines are less necessary, and you can delete them for a cleaner look. Use labels when there are few bars. With many bars, labels become crowded, so rely on the axis and a few highlighted values instead. Format the numbers with a thousands separator if the values are large.

Step 6: change colors and spacing

Click a bar, and in the Format tab choose a fill color. Use a single color for one series, and use a different color for a bar that you want to highlight, such as the largest region. In Format Data Series, change the Gap Width to a smaller number, such as 50 percent, to make the bars wider, or a larger number for thinner bars. Keep the colors consistent with your brand or report. Avoid bright rainbow colors, because color should carry meaning, not decoration.

Step 7: compare two years with clustered bars

Select A1:C5, which includes both years, and insert a Clustered Column chart. Excel shows two bars for each region, one for 2025 and one for 2026, and a legend that tells the colors apart. The North pair shows 400 and 450, the South pair 280 and 300, the East pair 350 and 380 and the West pair 200 and 220. Every region grew. Use the Overlap setting to place the bars closer, and use two related colors, such as light blue and dark blue, to distinguish the years.

Step 8: stacked bars for parts of a whole

A stacked chart places the series on top of each other, so the full bar shows the total, and the segments show the parts. If each region had two products, stacked columns would show the sales of each product and the total of the region. Choose Stacked Column or Stacked Bar in the chart menu. Use stacked charts with only a few segments, and put the most important segment at the bottom, since it is the easiest to compare. A 100% stacked chart shows the share of each segment instead of the totals.

Add a target or average line

To show a target line, add a column with the target value for every category, such as 340 for each region. Select the chart, choose Select Data and add the series. Then right-click the series, choose Change Series Chart Type and set it to Line. The line crosses all the bars, so readers see which regions are above or below the target. The average of 2026 is 1,350 divided by 4, which is 337.5, and North and East are above it. This is a good way to add context to the bars.

Fix common problems

If the chart shows the wrong series, open Select Data and check the ranges. If the categories appear as numbers 1, 2, 3 instead of names, edit the Horizontal Axis Labels and select the region names. If a total row appears as a bar, remove it from the chart range. If the bars are too thin, reduce the gap width. If the axis starts at a value other than zero, set the minimum to zero for bar charts, because the length of the bar must match the value, or the chart will exaggerate differences.

Common mistakes

The most common mistake is a value axis that does not start at zero, which makes small differences look large. Another is to use too many bars, so the chart is hard to read. A third is to use 3D effects, which distort the bars. A fourth is to sort the bars randomly, which makes comparison harder. A fifth is to use many different colors without meaning. A sixth is to leave out the units. A simple, sorted, labeled chart with one or two colors is almost always the best.

Practice problems

Try these. Problem 1: build a clustered column chart for the 2026 sales and identify the tallest bar, which is North with 450. Problem 2: sort the regions from the largest to the smallest and check that the order is North, East, South, West. Problem 3: compare the two years and find the region with the biggest growth in numbers, which is North with 50. Problem 4: add a target line at 340. Problem 5: change the chart to horizontal bars and reverse the category order.

Quick recap

Arrange the categories and values in columns, select them and choose Insert, Column or Bar chart. Use vertical columns for ordered categories and horizontal bars for long names. Sort the data, add titles and data labels, and keep the colors simple. Use a clustered chart to compare series, a stacked chart for parts of a whole and a line for a target. Start the value axis at zero, and keep the chart clean. A good bar graph lets the reader see the answer in a few seconds.

Frequently asked questions

How do I make a bar graph in Excel?

Select your data and choose Insert, then a Column or Bar chart.

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

Columns are vertical and bars are horizontal.

How do I sort the bars?

Sort the data in the sheet, and the chart follows.

How do I compare two series?

Use a clustered chart with both series selected.

How do I add a target line?

Add a series with the target and change its chart type to Line.

Related guides and free tools

Leave a Reply

Your email address will not be published. Required fields are marked *