You can make a bar graph in Excel without tearing your hair out. This guide covers Microsoft Office 365, Excel 2019, and even the older versions you might still be stuck on. It is a straightforward process. Once you learn it, you add a valuable skill to your toolkit.
What Is a Bar Graph?
Think of a bar graph as a visual translator for raw data. Also called a bar chart or column chart, it takes complex numbers and makes them easy to digest. You see them everywhere. School projects. Work presentations. Personal budgeting.
The structure is simple. It relies on two axes.
The x-axis is usually horizontal. The bars rise from it. The y-axis runs vertically. It holds the values along a range. This setup creates a vertical bar graph. Easy to remember because the bars stand up.
Flip it. A horizontal bar chart extends from the y-axis. The bars lie flat. You choose based on what looks better for your data.
Different Types of Bar Graphs in Excel
Not all data plays nice in a standard chart. Excel offers specific variations to handle different scenarios. You find these options in the column or bar chart menu.
Stacked Bar Chart
Use a stacked bar chart when you need to see multiple data series within a single category. Each bar gets subdivided.
Imagine quarterly earnings. Each vertical bar represents a quarter. But inside that bar, you can break down sales. Show online purchases in one color. In-person sales in another. It highlights the composition of the total.
Clustered Bar Chart
Clustered bar charts group bars side-by-side along the axis. The name gives it away. It is about comparison.
Compare different data types on the same graph. Say you run a nursery and try lasagna gardening. You want to know which companion planting combination yields the best results. Graph each combination in a clustered bar chart. You can see at a glance which plants outperform the others.
“Bar graphs are one of the most common and straightforward ways to visualize data, from the complex to the simple.”
The choice between stacked and clustered depends on what story you want the numbers to tell. Do you want to see parts of a whole? Or do you want to compare distinct groups? Excel handles both. You just need to know which button to click.
It starts with selecting your data. Then picking the chart type. The rest is formatting. But getting that first chart right sets the tone for everything else.
Visualizing Data with Excel Bar Graphs
Creating a bar graph in Excel 2016 is straightforward if you know where to look. Start by opening your spreadsheet. Highlight the data range. Don’t forget the headers. These become your labels. If your headers aren’t what you need, type them in manually before moving on.
Click the Insert tab. Look for the Insert Column or Bar Chart button in the Charts group. You’ll see a dropdown with plenty of options—2D columns, 3D columns, even 3D bars. Pick 2D columns. It’s usually the cleanest choice for standard reporting.
The chart appears instantly. You’ll see horizontal bars or vertical columns, depending on the subtype you picked, with your header names sitting along the bottom or side.
Next, give it a title. Click the Chart Title box at the top. It becomes editable. Type something descriptive. Vague titles don’t help anyone understand what they’re looking at.
Decide on placement. Do you want the graph embedded directly in the sheet? Or on its own separate sheet? Save the file. If you mess up, you can delete it entirely. Click the edge of the chart until you see the “chart area” tooltip. Hit the Delete key. Start over.
Navigating Older Excel Versions (2003 and 2007)
Things work differently in older versions of Excel. The interface is clunkier. The logic is the same, but the clicks are different.
Open your file. Select your data. Include headers. This step is non-negotiable if you want readable labels.
Click the Chart Wizard button on the toolbar. Alternatively, go to the Insert menu and choose Chart.
Ensure Column is selected as the chart type. It’s the default. Choose a subtype from the options on the right. Click Next.
Verify the data range. Check the DataRange tab to make sure everything is selected correctly. Click Next again.
Enter titles for your X and Y axes. These labels will show up on the graph itself. Go through the other tabs in the wizard. Adjust settings if you need to. Click Next.
Choose where the chart goes. Embedded or new sheet. Click Finish.
You’re done. Mostly. Use the Chart toolbar to make final tweaks. If you don’t see the toolbar, go to View, select Toolbars, and check Chart.
Common Excel Chart Questions
People often get stuck on specific chart behaviors. Here are answers to common queries about creating and modifying graphs in Excel.
How do I create a basic graph in Excel?
Enter your data first. Select the range. Go to Insert and pick your chart type. If the axes look swapped, switch the data series. Adjust colors and layout to match your brand or preference. Resize the legend and axis labels so they’re readable. Change Y-axis measurement options if the scale doesn’t fit your data range. Reorder your data if the sorting is off. Add a clear title.
How do you create a chart using recommendations?
Highlight your data. Go to Insert > Recommended Charts. Excel suggests layouts based on your data structure. Pick one from the Recommended Charts tab. Click OK. It’s a quick way to get a professional-looking baseline without hunting through menus.
How do you make an XY scatter graph with a trendline?
Select your data. Open the chart wizard. Choose an X-Y Scatter graph. Click Finish. Click a data point on the chart to highlight the series. Go to Chart > Add Trendline. Select Linear regression. Click the Options tab. Check Display equation on chart and Display R-squared value on chart. This adds statistical context directly to the visual.
How do I show hidden data in a graph?
Sometimes data is hidden, and the graph ignores it. That’s annoying. Select the chart. Click the Design tab. In the Data group, click Select Data. Find the Hidden and Empty Cells button. Select Show Data in Hidden Rows and Columns. Click OK twice. The missing data points will reappear.
