We use essential cookies to make Venngage work. By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.

Manage Cookies

Cookies and similar technologies collect certain information about how you’re using our website. Some of them are essential, and without them you wouldn’t be able to use Venngage. But others are optional, and you get to choose whether we use them or not.

Strictly Necessary Cookies

Always Active

These cookies are always on, as they’re essential for making Venngage work, and making it safe. Without these cookies, services you’ve asked for can’t be provided.

Show cookie providers

  • Venngage
  • Amazon
  • Google Login
  • Intercom

Functionality Cookies

These cookies help us provide enhanced functionality and personalisation, and remember your settings. They may be set by us or by third party providers.

Show cookie providers

  • Venngage
  • Chameleon
  • Intercom
  • Algolia

Performance Cookies

These cookies help us analyze how many people are using Venngage, where they come from and how they're using it. If you opt out of these cookies, we can’t get feedback to make Venngage better for you and all our users.

Show cookie providers

  • Venngage
  • Mixpanel
  • Intercom
  • Google Analytics
  • Hotjar

Targeting Cookies

These cookies are set by our advertising partners to track your activity and show you relevant Venngage ads on other sites as you browse the internet.

Show cookie providers

  • Google Ads
  • Google Tag Manager
  • Facebook
  • Pinterest
  • Product
  • Templates
  • Learn
  • Pricing
Educational Resources
Help Center
Help Center

How To Create A Bar Chart In Excel

Written by: Aditya Rana

Jul 26, 2023

how to make bar chart in excel

We’ve all heard of bar charts.

I’m sure you’ve used them at some point, whether for a school assignment or to present data in a creative way for your company presentation or report. 

What’s not to love about them?

They’re simple, effective, visually appealing and provide a versatile way to display frequency distributions, making them an essential tool in data analysis.

And most of us are able to flop around in Microsoft Excel or Google Sheets to create one.

But is that really the best method?

In this post, I’ll show you how to create a bar chart with Excel and then show you a better way with Venngage’s Bar Graph Maker.

If you want to go a step beyond and save more time and energy, check out our customizable bar chart templates instead.


Click to jump ahead:

Exploring bar chart basics

Before I show you how to create a bar graph in Excel, let’s understand some basics first.

A bar graph has two axes — the horizontal X-axis, and the vertical Y-axis. The X-axis showcases categories of data, and the Y-axis is used to present numerical values.

The height of the rectangular bars in a bar graph represents the magnitude of actual data points.

Here’s an example:

Colorful Bar Chart Template

However, bar graphs do not convey information about variance or statistical measure that shows the spread of values or the standard deviation.

If you want to include that information, it’s better to consider box plots instead.

For a more comprehensive overview of bar charts, check out this post:

Other factors you’ll want to keep in mind include the labels, which provide a description of what each axis represents and gridlines that can be added to aid interpretation.

I’ve labeled this bar chart with all the information you need to know:

labeled bar chart

Oh and one more thing. 

Though not common, sometimes bar charts can include an additional horizontal or vertical secondary axis when there are more than two sets of data.

For example, let’s say you have a bar graph showing the sales revenue of different products on the primary vertical axis. To show the number of units sold for each product, you might add a secondary vertical axis. 

Types of bar charts in Excel

Excel is known for helping people create several types of charts for different presentation needs.

Besides the column chart in Excel, other options include a pie chart, line chart, and scatterplot

Not sure if a bar chart is the right choice for you? Check out our post on how to choose the best chart for your data to help you decide.

But if you’re confident a bar graph is what you need, the next step is to decide what type of bar chart you want to create.

Excel provides various options for bar charts, including clustered, stacked, floating, and grouped bar charts, as well as histograms.

For example, a stacked bar chart is helpful in comparing percentages or proportions within different categories while a clustered bar chart allows for straightforward comparisons of data across categories.

However, you won’t find each type of bar chart in Excel.

For instance, it’s not possible to create a timeline or schedule bar chart (also known as a Gantt chart) in Excel unless you want to spend hours manually customizing the appearance. 

So why not head over to our selection of bar chart templates where you’ll find each of these types of bar charts ready to be made your own in a few clicks?

Now, onto the type bar charts you can create in Excel: 

Clustered bar chart – comparing data at a glance

A clustered bar chart in Excel displays multiple bars placed side-by-side for easy data comparison.

Excel offers both 2D and 3D clustered bar chart options, which are widely used for data comparison.

cluster bar chart excel

Here’s an example of a clustered bar chart: 

Clustered Stacked Bar Chart

Clustered bar charts allow you to add overlapping bars to compare multiple series of data.

In the example above, the adjacent nature of the clustered bars makes it easy to visualize how each cake flavor performs in different cities.

Stacked bar chart – visualizing cumulative totals

In a stacked bar chart, bars are stacked on top of each other to represent the cumulative total of multiple data series.

Each segment within a bar represents a different category or group, and the overall height of the bar represents the total value.

Of course, you can create stacked bar charts in Excel too.

stacked bar charts excel

Here’s a real-world example:

Free Chart Template

How to make a bar chart in Excel

Depending on your version of Excel, the user interface may look a bit different, but the process should be similar.

I’m using the now ancient Excel 2010 because I love its simplicity.

Start by entering the data you want to represent in a bar graph.

For example, let’s say I want to visualize the five largest countries in the world.

Here’s an overview of the steps to create a bar chart in Excel:

  1. Select the data range you want to include in a bar chart
  2. Click on “Insert” in Excel’s tab manager and select “Bar”
  3. Choose a desired bar chart type, such as clustered column chart or stacked bar
  4. Wait for Excel to create the chart
  5. Customize the chart by selecting it and then clicking on “Chart Tools” in the ribbon. Here, you’ll see options to change the design, format, and layout
  6. Save and export

By the way, if you have a large dataset, I recommend using Excel’s pivot table feature to organize data in a structured way.  

Moreover, you can easily create pivot charts from pivot tables, allowing dynamic visualizations that update as you modify your data.

Here’s a visual walk-through:

Step 1 – Enter your data

First, enter the data you want to visualize in a bar graph.

bar chart data

Step 2 – Click “Insert” and select your bar chart type

Next, while selecting your data, click on “Insert”.

excel bar chart insert

Select the “Bar” option.

insert bar chart option excel

Step 3 – Customize your chart

Select your bar chart and Excel should update the ribbon with more options under “Chart Tools”.

excel chart tools

Some design options here include the ability to customize colors using the conditional formatting feature and fill effects to add colors and visual cues based on specific data conditions, making it easy to highlight certain trends.

Excel also allows you to add vertical lines as an extra visual element to indicate significant events or milestones.

You can also add borders and outlines to the bars to create a visual distinction or emphasize specific data points.

Meanwhile, under Layout and Format, you can customize the labels and titles for both the x-axis (horizontal) and y-axis or format data labels to enhance readability and presentation.

How to make better bar charts with Venngage

Of course, Excel isn’t the only way to make a column chart.

With limitations in flexibility, customization options, or the ability to edit and collaborate in real time, Excel is not the best way to create bar charts.

With Venngage, you can really elevate your bar charts thanks to our intuitive editor tool and professional bar chart templates that showcase progress and key performance indicators effectively.

Here’s what you need to do:

Step 1 – Sign up for a Venngage account (it’s free!)

Start by signing up for Venngage with your email, Gmail or Facebook account.

venngage sign up

Step 2 – Select a template from our library

Venngage has a diverse range of bar chart templates to choose from. Whether you’re looking for stacked bar charts, a vertical bar graph, or a horizontal bar chart, we’ve got templates for you to edit.

bar chart templates venngage

For example, here’s a beautiful stacked bar chart you can make your own:

Thermometer Graph Marketing Stats Template

Or this stunning horizontal bar chart.

Visual Content Marketing Design Bar Chart

Step 3 – Edit your bar chart in a few clicks

Have no design experience? No sweat!

All our templates are easy to edit thanks to a drag-and-drop interface.

bar graph maker gif

Swap placeholder data with your own in a spreadsheet interface.

But that’s not all.

Venngage also offers 40,000 icons and illustrations to help you visualize and bring bar charts to life. This will ensure your next assignment, presentation, or report is not dull and grey.

And if you upgrade to a Business account, you can also enjoy My Brand Kit — the one-click branding kit that lets you upload your logo and apply brand colors and fonts to any design.

venngage my brand kit

A business account also includes a real-time collaboration feature, so you can invite members of your team to work simultaneously on a project.

Step 4 – Share a link to your bar chart for free or upgrade to download

When you upgrade to a Business account, you can download your quote poster as a PNG, PDF, or interactive PDF.

But you can always share your quote poster online for free.

Frequently Asked Questions

How to make a column graph in Excel?

To create a column graph in Microsoft Excel, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a column graph, 4) Choose a column chart type, 5) Let Excel create the chart, 6) Customize the bar chart to your needs, and 7) Save and export. 

How to make a grouped bar chart in Excel?

To create a grouped bar chart in Excel, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a grouped bar chart, 4) Customize your chart, 5) Add axis labels and titles, and 6) Save and export.

How to make a percentage bar graph in Excel?

To create a percentage bar graph in Excel, follow these steps: 1) Enter your data, 2) Calculate your percentages, 3) Select your data range, 4) Insert a clustered column bar chart, 5) Switch to the percentage scale, 6) Customize the chart, 7) Add axis labels and titles, and 8) Save and export.

How to make a bar graph in Excel with 3 variables?

To make a bar graph in Excel with 3 variables, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a clustered column chart, 4) Customize your chart, 5) Add axis labels and titles, and 6) Save and export your clustered bar chart. 

How to make a double bar graph in Excel?

To create a double bar graph in Excel, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a clustered bar chart, 4) Customize your chart, 5) Add axis labels and titles 6) group the bars by right-clicking on a bar and selecting “Format Data Series” from the menu. Here, change “Series Overlap” and “Gap Width” settings to adjust the spacing between the bars to 0 to create a double bar graph, and 7) Save and export. 

How do I create a bar chart in Excel with multiple bars?

To create a bar chart in Excel with multiple bars, follow these instructions: 1) Enter your data, 2) Select your data range, 3) Choose the type of bar chart you want to create, 4) Select the “Chart Design” option in the “Data” tab and click on “Switch Row/Column” button, 5) Save and export.

In summary: Unlock the potential of your data and captivate your audience with beautiful bar charts

With Venngage, it’s easy to elevate your data visualization game and create stunning bar charts that grab the attention of a reader or audience.

Or you can make boring bar charts with Excel that puts people to sleep.

What choice will you go with?

About Aditya Rana

Adi is a word slinger and loves to fiddle around with SaaS. When not living online, you'll find him outside in nature with a book.