Easy Tech TutsHow to Make a Bar Graph in Microsoft Excel Easily 2026
By Impran M N
Presenting quarterly metrics or performance data as raw numbers makes it harder for your audience to spot trends quickly. This guide covers organizing your source table, inserting a clustered bar chart, customizing its colors and labels, and confirming it updates automatically when your data changes.
01Organize your data
Place your categories in the first column and numerical values in the adjacent columns, including header titles.
02Select your data range
Highlight the full range of data you want charted, making sure to include the header row.
03Insert the chart
Go to the Insert tab, open the Insert Column or Bar Chart dropdown, and choose Clustered Bar for a horizontal layout.
04Position and title the chart
Drag the chart into place, then double-click the header text box to type a custom title.
05Customize colors
Right-click a bar, open the Fill color tool, and pick a cohesive color palette.
06Add labels and verify updates
Use the Chart Elements icon to add data labels or axis titles, then change a value in your table to confirm the chart updates automatically.
Frequently asked questions
What's the difference between a clustered bar and a column chart?
A clustered bar chart displays horizontally while a column chart displays vertically, so the choice comes down to which orientation reads better for your data.
Will my chart update automatically if I change the source numbers?
Yes, Excel charts are linked live to the source cells, so updating a value automatically adjusts the chart's height and scale.
Can I add data labels directly on the bars?
Yes, the Chart Elements plus icon lets you check a box to display data labels directly on each bar.
Do I need to include the header row when selecting data?
Yes, including the header row helps Excel automatically generate accurate category and series names for your chart.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
