The Basic Steps to Build a Bar Graph

A bar graph in Excel starts with your data already in the spreadsheet. You select the numbers you want to show, click the Insert menu, choose Chart, and pick the bar chart style. Excel then builds the graph and places it on your sheet. The whole process takes about two minutes once your data is organized.

The reason this works is that Excel needs to see your data in columns or rows before it can draw anything. If your numbers are scattered across the sheet or mixed with text, the chart will look wrong. That's why organizing your data first — the way the previous guide explained — makes this step much faster.

Key Takeaways

  • Your data must be in adjacent columns or rows, with numbers in one column and labels in another, before you start building the chart.
  • Select all the data you want in the graph, then go to Insert > Chart and choose the bar chart type that matches what you're showing.
  • Excel places the chart on top of your data by default, but you can drag it to a blank area of the sheet so it doesn't cover your numbers.
  • You can change the title, axis labels, and colors after the chart is made by right-clicking on each part and selecting Edit or Format.
  • Save your file after creating the chart — the graph is part of the spreadsheet and will stay there when you reopen it.

Setting Up Your Data So Excel Can Read It

Excel's chart tool works best when your data is in a straightforward table: one column for the category names (like months, product names, or regions) and one or more columns for the numbers you want to display. Put the labels in the first row if you have them — Excel will recognize these as titles and use them in the chart automatically.

For example, if you're showing sales by month, your setup should look like this: Column A has the month names (January, February, March), and Column B has the sales numbers (5000, 7200, 6800). Don't leave blank rows between your data, and don't mix text and numbers in the same column. Excel will either skip the blank rows or get confused about what to chart.

If your data is already spread across the sheet from earlier work, take a minute to copy it into a clean area with no gaps. This prevents Excel from creating a chart that only includes part of what you want to show.

Selecting Your Data and Inserting the Chart

Click on the first cell of your data (usually the label in the top-left corner) and drag to the last cell that contains a number you want in the chart. This selection should include your category names and all the numbers. You'll see the selected area highlighted in blue.

Once your data is selected, click the Insert menu at the top of the screen. Look for the word "Chart" — in newer versions of Excel it may say "Insert Chart" or show a small chart icon. Click it, and a dialog box will open showing different chart types. Find "Bar Chart" or "Column Chart" (they're similar — column charts are vertical bars, bar charts are horizontal). Click the style you want, then click OK or Insert.

Excel will place the chart directly on your spreadsheet, usually covering some of your data. This is normal. You can click the chart and drag it to the right or below your data so you can see both the numbers and the graph.

Changing the Title and Labels

When the chart first appears, it may have a generic title like "Chart Title" or no title at all. To add or change the title, click once on the chart to select it, then click on the title text itself. You'll see a cursor appear, and you can type a new title. Press Enter when you're done.

The axes — the lines on the left and bottom of the chart — may also need labels. Right-click on the chart and look for an option that says "Edit Chart" or "Chart Elements." In newer Excel versions, you'll see a small plus sign appear next to the chart when it's selected; click that and check the box for "Axis Titles." You can then click on each axis label and type what it represents (for example, "Sales" on the vertical axis and "Month" on the horizontal one).

Don't worry about making these perfect the first time. You can always click the chart again later and adjust the title or labels whenever you need to.

Changing Colors and Chart Style

Excel's default colors are fine for most uses, but you can change them if you want. Click the chart once to select it, then right-click on one of the bars. Choose "Format Data Series" or "Format Data Point." A panel will open on the right side of the screen with color options. Click the paint bucket icon and pick a new color.

If you want to change the entire look of the chart — for example, switching from vertical bars to horizontal bars — click the chart, then look for a "Chart Type" button or right-click and select "Change Chart Type." The same dialog that appeared when you first created the chart will open, and you can pick a different style.

You can also change the background color of the chart itself by right-clicking on the white area behind the bars and selecting "Format Chart Area." Most of the time, though, the default appearance works fine and doesn't need changes.

Moving and Resizing Your Chart

Click on the chart once to select it — you'll see a border with small squares around the edges. To move it, click anywhere inside the chart (but not on a bar or label) and drag it to a new location. To resize it, click and drag one of the small squares on the border. Drag a corner square to make it bigger or smaller while keeping the same proportions.

If you want the chart on a separate sheet by itself, right-click the chart and choose "Move Chart." Select "New Sheet" and Excel will create a blank sheet just for that chart. This is useful if you have a large graph you want to print on its own page.

Saving Your Chart

Your chart is automatically part of the spreadsheet file. When you save the file using Ctrl+S (or Command+S on a Mac), the chart saves along with your data. You don't need to do anything special — the chart will be there the next time you open the file.

If you want to copy the chart to another program like Word or PowerPoint, right-click it and choose "Copy." Then go to the other program and paste it. The chart will appear as an image, and you can resize it there, but you won't be able to edit the data from the other program — you'll have to go back to Excel to make changes.

Frequently Asked Questions

What if my data has text in the numbers column?

Excel will skip any cells that contain text and only chart the numbers. If you have entries like "5,000 units" instead of just "5000", Excel may not recognize them as numbers. Remove the text and units, leaving only the numbers, and the chart will work correctly.

Can I show multiple sets of numbers in one chart?

Yes. If you have two columns of numbers (for example, sales and expenses), select both columns along with your category labels, then insert the chart. Excel will create bars for each set of numbers, usually in different colors, so you can compare them side by side.

Why does my chart look blank or show only part of my data?

This usually happens when you didn't select all your data before inserting the chart, or when there are blank rows in the middle of your data. Click the chart, right-click it, and choose "Select Data." You'll see which cells Excel thinks contain your data. Add or remove cells as needed to include everything you want to show.

Can I print just the chart without the data?

Yes. Click the chart to select it, then go to File > Print. Excel will print only the selected chart. If you don't select the chart first, it will print the entire sheet with both the data and the chart.

What's the difference between a bar chart and a column chart?

A column chart has vertical bars (taller than they are wide), and a bar chart has horizontal bars (wider than they are tall). They show the same information — it's just a matter of which direction looks better for your data. Use whichever one is easier to read.