The fastest way to make a bar chart in Excel
A bar diagram in Excel takes about 30 seconds to create once your data is in place. Select the numbers you want to show, click the Insert tab, choose Bar Chart, and Excel builds the diagram for you. The chart appears on the same sheet as your data and updates automatically if you change the numbers.
The real work is arranging your data correctly before you insert the chart. Excel reads the layout of your cells to decide what goes on the horizontal axis, what goes on the vertical axis, and what the bars represent. Get the layout right, and the chart builds itself. Get it wrong, and you spend time fixing labels and values that ended up in the wrong place.
Key Takeaways
- Arrange your data in two columns or rows: one for labels (like product names or months) and one for the numbers you want to show as bars.
- Select both the labels and the numbers together before inserting the chart, so Excel knows which is which.
- The Insert tab holds the Bar Chart button; clicking it opens a menu of bar chart styles to choose from.
- After the chart appears, you can change the title, axis labels, and colors by right-clicking the chart and selecting Edit Chart.
- Excel updates the bars automatically whenever you change a number in the original data cells.
How to arrange your data before making the chart
Excel needs your data in a straightforward grid: one column or row for the category names (what each bar represents) and another column or row for the numbers (the height of each bar). If you are comparing sales by region, put the region names in one column and the sales numbers in the next column. If you are showing monthly revenue, put the month names in one row and the revenue amounts in the row below.
The labels and numbers must be next to each other with no empty cells between them. If your data looks like this, Excel will read it correctly:
| Product | Sales |
| Widget A | 450 |
| Widget B | 320 |
| Widget C | 580 |
Include the header row (the row with "Product" and "Sales") when you select your data. Excel uses the headers to label the axes and the legend, so including them saves you work later.
Selecting your data and inserting the chart
Click on the first cell of your data (usually the header) and drag to the last cell that contains a number. If your data is in columns A and B from row 1 to row 4, click on cell A1 and drag to B4. The selected cells will highlight in blue. Do not select empty cells or unrelated data — Excel will try to include them in the chart.
Once your data is selected, click the Insert tab at the top of the ribbon. Look for the Charts section. Click the Bar Chart button (it looks like horizontal bars) or the Column Chart button (it looks like vertical bars). A menu appears showing different styles of bar charts. Click the style you want — usually the first option, a straightforward bar chart with no special effects, is the right choice.
Excel inserts the chart on your sheet. The chart is a separate object that sits on top of your data. You can click and drag it to move it to a different location on the sheet, or resize it by dragging the corners.
Changing the chart title and labels
By default, Excel gives your chart a generic title like "Chart Title". To change it, double-click the chart to enter edit mode (the chart gets a gray border around it). Click on the title text and type a new title. Press Enter when you are done.
To change the axis labels, right-click the chart and select Edit Chart. Click the Chart Design tab that appears. Look for Add Chart Element and click it. Select Axis Titles, then choose which axis you want to label. Type the label you want — for example, "Sales in Dollars" for the vertical axis or "Region" for the horizontal axis.
If the category names on your horizontal axis are hard to read because they overlap, right-click the axis itself and select Format Axis. Under Text Options, change the angle to 45 degrees so the names tilt and take up less space.
Changing colors and chart style
Double-click the chart to enter edit mode. Click on one of the bars to select all the bars. Right-click and choose Format Data Series. Under Fill, select Solid Fill and pick a color from the palette. All the bars change to that color at once.
To use different colors for different bars, click once on a single bar (not the whole series) and then right-click it. Choose Format Data Point and pick a color for just that bar. Repeat for each bar you want to change.
If you want to switch from a bar chart (horizontal bars) to a column chart (vertical bars), right-click the chart and select Change Chart Type. Pick Column Chart from the list. The same data now displays as vertical bars instead of horizontal ones.
What happens when you change the original numbers
The chart is linked to the cells you selected when you created it. If you change a number in one of those cells, the bar in the chart updates when ready. If you change "Widget A" sales from 450 to 600, the bar for Widget A grows taller right away. You do not have to recreate the chart.
If you add new data below your original selection, the chart does not automatically include it. You have to edit the chart's data range. Right-click the chart, select Select Data, and drag to include the new cells. After that, the new bars appear in the chart.
Common mistakes and how to fix them
The most common mistake is selecting data that has empty rows or columns in the middle. Excel treats the empty space as a break in the data and may create multiple chart series instead of one. Before you insert the chart, delete empty rows and columns from your selection.
Another mistake is forgetting to include the header row. Without headers, Excel labels your axes with generic names like "Series 1" and "Series 2". If this happens, right-click the chart and select Select Data. Check the box that says First Row as Labels (or First Column as Labels if your data is arranged horizontally).
If your numbers are very different in size — for example, one bar is 10 and another is 5,000 — the small bars become invisible. You cannot fix this by changing colors. Instead, consider making two separate charts, one for each group of numbers, or ask yourself whether comparing them in one chart makes sense.
Frequently Asked Questions
Can I make a bar chart from data in different sheets?
No. Excel can only create a chart from data on the same sheet where the chart appears. Copy the data you need to the sheet where you want the chart, or move the chart to the sheet that holds the data.
How do I add a legend to my bar chart?
Double-click the chart to edit it. Click the Chart Design tab. Click Add Chart Element and select Legend. Choose where you want it to appear — right, left, top, or bottom. If you have only one data series, the legend may not be necessary.
What is the difference between a bar chart and a column chart?
A bar chart has horizontal bars that extend left to right. A column chart has vertical bars that extend bottom to top. They show the same information in different orientations. Use whichever looks clearer for your data.
Can I delete the chart without deleting my data?
Yes. Click the chart once to select it (not double-click, which enters edit mode). Press Delete. The chart disappears but your original data stays in place.
How do I print just the chart without the data?
Click the chart to select it. Go to File and click Print. Excel prints only the selected chart. If you do not select the chart first, it prints the entire sheet including all data.