A bar chart in Excel takes your data and turns it into a visual comparison

A bar chart shows amounts side by side so you can see which category is biggest at a glance. To make one in Excel, you select the data you want to compare, click the Insert menu, pick Chart, and choose the bar style you want. Excel does most of the work — it reads your numbers, draws the bars to scale, and labels them automatically. The whole process takes about two minutes once you know where to click.

Bar charts work best when you have a handful of categories (like sales by region, or budget by department) and you want to compare their sizes. If you have dozens of categories or you need to show change over time, a different chart type might work better — but a bar chart is the right choice for straightforward side-by-side comparison.

Key Takeaways

  • Select your data first — the category names in one column and the numbers you want to compare in the next column.
  • Click Insert, then Chart, then choose Bar Chart from the menu to let Excel build the chart automatically.
  • Excel places the chart on the same sheet as your data, and you can move it or resize it by clicking and dragging.
  • Double-click the chart to edit the title, axis labels, or colors if you want to change how it looks.
  • Bar charts work best for comparing five to ten categories; more than that and the labels get crowded.

Organize your data in two columns before you start

Excel needs your information in a specific shape to build a chart. Put your category names in one column — these are the labels that will appear along the bottom or side of your chart. Put the numbers you want to compare in the column right next to it. For example, if you are comparing sales by region, column A might say "North," "South," "East," "West," and column B might say 45000, 38000, 52000, 41000.

Include a header row at the top of each column. Type something like "Region" in cell A1 and "Sales" in cell B1. Excel uses these headers as labels on your chart, so make them clear and short. Do not leave blank rows or columns in the middle of your data — Excel will stop reading when it hits a gap.

If your data is spread across multiple sheets or mixed with other information, copy just the two columns you need into a clean area first. This takes 30 seconds and prevents Excel from getting confused about what to chart.

Select the data range, then open the Insert menu

Click on the first cell of your data (usually the header in column A) and drag to the last cell in column B that contains a number. You should see a blue highlight over all the cells you selected. If you selected too much or too little, click somewhere else to start over and try again.

Once your data is highlighted, click the Insert tab at the top of the ribbon. You will see a row of buttons for different types of content. Look for the button that says Chart — it usually shows a small bar graph icon. Click it.

Choose Bar Chart from the chart type menu

A window will open showing different chart styles. On the left side you will see a list of chart types: Column, Bar, Line, Pie, and others. Click on "Bar Chart" (or "Column Chart" if you want vertical bars instead of horizontal ones — both work the same way, just rotated). The difference is small: column charts have bars going up and down, bar charts have bars going left to right. Pick whichever looks clearer for your data.

Once you click the chart type, Excel shows you a few style options on the right. The first option (usually a straightforward bar chart with no extra decoration) is fine for most purposes. Click it, then click OK or Insert at the bottom of the window.

Excel places the chart on your sheet and you can move it

Your chart will appear on the same sheet as your data, usually overlapping it. The chart is selected (you will see a border around it), so you can click and drag it to a new location. Move it to the right of your data, or below it, or to a blank area of the sheet — wherever makes sense for how you plan to use the spreadsheet.

To resize the chart, click on one of the small squares at the corners or edges and drag outward to make it bigger, or inward to make it smaller. Keep the chart large enough that the labels are readable — if the category names are too small to read, make the chart wider.

Edit the title and labels by double-clicking the chart

Double-click anywhere on the chart to enter edit mode. You will see the chart has a gray border and the spreadsheet behind it is grayed out. Now you can click on different parts of the chart to change them. Click on the title at the top to edit it — change it from "Chart Title" to something that describes what you are showing, like "Sales by Region" or "Monthly Expenses."

Click on the axis labels (the words along the bottom or left side) to edit those too. You can also right-click on the bars themselves to change their color, or click on the legend (the box that explains what each bar means) to move it or hide it. When you are done editing, click outside the chart to exit edit mode.

If you want to change the data the chart is based on — for example, you added a new region and want to include it — double-click the chart, then right-click on the chart area and look for an option like "Select Data" or "Edit Data." This lets you tell Excel which cells to include.

Use a bar chart when you have a few categories to compare

Bar charts shine when you have roughly three to ten categories and you want to see which one is biggest. They are straightforward to read at a glance and they work well in presentations or reports. If you have more than ten categories, the labels get crowded and the chart becomes hard to read — in that case, consider filtering your data to show only the top categories, or using a different visualization.

Bar charts are not the right choice if you need to show how something changes over time (use a line chart for that) or if you want to show how parts add up to a whole (use a pie chart). But for straightforward comparison — which salesperson sold the most, which department spent the most, which product got the most orders — a bar chart is the clearest choice.

Frequently Asked Questions

Can I change the colors of the bars after I create the chart?

Yes. Double-click the chart to enter edit mode, then right-click on one of the bars and choose "Format Data Series." A panel will open where you can pick a new color. You can make all bars the same color, or click on individual bars to color them differently.

What if my data has more than two columns?

Excel can handle it. If you select three columns — for example, Region, 2023 Sales, and 2024 Sales — Excel will create bars that show both years side by side for each region. This is called a grouped bar chart and works well for comparing two related numbers across categories.

How do I delete a chart I do not want anymore?

Click on the chart once to select it (you will see the border around it), then press Delete. The chart disappears but your data stays. If you delete it by accident, press Ctrl+Z to undo.

Can I print just the chart without printing the data?

Yes. Click on the chart to select it, then go to File and Print. Excel will print only the selected chart. If you do not select the chart first, it will print the whole sheet including the data.

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

A column chart has bars that go up and down (vertical). A bar chart has bars that go left and right (horizontal). They show the same information — the choice is just which direction looks clearer for your data. Use whichever makes your labels easier to read.