Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > Bar Graph in Excel — All 4 Types Explained Easily (Excel Sheet Included)

Bar Graph in Excel — All 4 Types Explained Easily (Excel Sheet Included)

Note: This guide on how to make a bar graph in Excel is suitable for all Excel versions. 

Bar graphs are one of the most simple yet powerful visual tools in Excel. Bar graphs are very similar to column charts, except that the bars are aligned horizontally.  

Related: 

How To Find Duplicates In Excel? The Best Guide

Excel Goal Seek—the Easiest Guide (3 Examples)

Create A Pivot Table In Excel—the Easiest Guide

They are very useful when you want to compare categorical data across variables. Use it especially when the category names are long or to display any sort of duration value. 

In this guide, I’ll teach you how to make a bar graph in Excel the easy way, with plenty of illustrations. By the end of this article, you should be able to create and format bar graphs in Excel with ease. 

Please find the sample Excel Sheet used in this guide below. You can use it to follow along with me. 


In this guide, I’ll cover,

  1. Bar Graph in Excel – An Overview 
  2. How to Make a Bar Graph in Excel?
  3. How to Format a Bar Chart in Excel?
  4. Let’s Wrap Up


Bar Graph in Excel – An Overview 

An Excel bar graph or bar chart plots horizontal bars of data across different categories in a simple way. The X-axis indicates the values of the secondary variable and the Y-axis represents the various categories. 

A simple bar graph in Excel
A simple bar graph in Excel

This is just a simple bar graph example. Bar charts in Excel can be tweaked to include multiple variables, display percentages, stack bars of data etc. 

I’ll explain all these with examples. 

Also Read: 

How To Use Excel Countifs: The Best Guide

Excel Conditional Formatting -the Best Guide (Bonus Video)

The Best Excel Project Management Template In 2021

How to Make a Bar Graph in Excel?

To make any bar graph, you should prepare your data beforehand. It should have one categorical variable and one or more secondary variables. Now let me show you how to create various types of Excel bar graphs.

How to create a Simple Bar Graph?

To create a simple bar graph, follow these steps: 

  1. Get your Data ready. Make sure it has one categorical variable and one quantitative secondary variable. In my example from Sheet1, I have the time duration of 6 tasks. 
  1. Select your Data with headers.
  1. Locate and click on the 2-D Clustered Bars option under the Charts group in the Insert Tab. 
Select 2D-Clustered Bars  - Bar graph in Excel
Select 2D-Clustered Bars from the Charts group in the Insert Tab
  1. Your bar graph will now appear in the same sheet. You can edit its formatting if needed. 
Simple Bar Graph in Excel
Simple Bar Graph in Excel
Simple Bar Graph Result
Simple Bar Graph Result

How to Make a Bar Graph with Multiple Variables?

To create a bar graph with multiple variables, follow these steps. Refer to Sheet2 from the sample Excel file to follow along with me. 

  1. Make sure your data has one categorical variable and multiple quantitative secondary variables. 
  1. Select your Data with headers
  1. Locate and click on the 2-D Clustered Bars option under the Charts group in the Insert Tab. 
  1. Your bar graph will now appear in the same sheet. You can edit its formatting if needed and change its title. 
Click on the 2-D Clustered Bars option under the Charts group in the Insert Tab
Click on the 2-D Clustered Bars option under the Charts group in the Insert Tab
Bar Graph with clustered columns  in Excel
Bar Graph with clustered columns

How to create a Stacked Bar Graph in Excel?

Use a stacked bar graph when you need to compare parts of a whole across categories. 

To create a stacked bar graph with multiple variables, follow these steps. Refer to Sheet3 from the sample Excel file to follow along with me.

  1. Select your data with the headers. 
  1. Locate and click on the 2-D Stacked Bars option under the Charts group in the Insert Tab. 
  1. Your stacked bar graph will now appear in the same sheet. Edit its formatting if needed and change its title. 
Click on the 2-D Stacked Bars option under the Charts group in the Insert Tab
Click on the 2-D Stacked Bars option under the Charts group in the Insert Tab

Add data labels by clicking on the “Plus” symbol next to the chart and selecting the Data Labels option. 

Stacked Bar Graph in Excel
Stacked Bar Graph in Excel

How to Make a Percentage Bar Graph in Excel?

Use a percentage bar graph when you need to see how much percentage each variable contributes to the total across categories. 

To create a percentage bar graph, follow these steps. 

Refer to Sheet4 from the sample Excel file to follow along with me.

  1. Select your data with the headers. It must contain variables that add up to a total or make a part of the total. 
  1. Locate and click on the 100% Stacked Bars option under the Charts group in the Insert Tab. 
  1. Your percentage bar graph will now appear in the same sheet. Edit its formatting if needed and change its title. 
Click on the 100% Stacked Bars option under the Charts group in the Insert Tab
Click on the 100% Stacked Bars option under the Charts group in the Insert Tab

Add data labels by clicking on the “Plus” symbol next to the chart and selecting the Data Labels option. 

Percentage Bar Graph in Excel
Percentage Bar Graph in Excel

How to Format a Bar Chart in Excel?

To illustrate how to format a bar chart, I am using the bar chart from Sheet1. But this guide is applicable to all types of bar charts. Follow these steps:

  1. You can change the Chart title by double-clicking on it and typing in the new title. 
Double click on the Chart Title to edit it
Double click on the Chart Title to edit it
  1. You can add Chart Elements by clicking on the “Plus” symbol next to the chart and choosing the required element. 
    Select or deslect the chart elements you want to include in the bar chart. For example you can remove the gridlines from the background by unchecking the gridline box.
Add Chart Elements by clicking on the "Plus" sign next to your bar chart
Add Chart Elements by clicking on the “Plus” sign next to your bar chart
  1. To format the bar graph right click on the chart area and select the Format Chart Area option. 
    You can change the Fill type, border colour, thickness etc. Experiment with all of these options or just change things you need.
Under Format Chart Area panel change the Border colour, type, Fill etc of the chart area
Under Format Chart Area panel change the Border colour, type, Fill etc of the chart area
  1. Similarly, click on the plot area or the axes to edit their formatting in the “Format Plot Area” or “Format Axis” panes respectively. Here, the axis colour, thickness, data label appearance etc can be edited.
Similarly, you can edit the formatting using the Format Axis and Format Plot Area panes
Similarly, you can edit the formatting using the Format Axis and Format Plot Area panes

Suggested Reads: 

Create An Excel Dashboard In 5 Minutes – The Best Guide

Dynamic Dropdown Lists In Excel – Top Data Validation Guide

Predict Future Values Using Excel Forecast Sheet – The Best Guide

FAQs

What is a subdivided bar graph?

A subdivided bar graph is nothing but a stacked bar graph, which shows how different variables add up to a total. It is used to easily find the contribution of each variable. 

What are the types of bar graphs?

There are actually 4 types of bar graphs available in Excel. 
Simple bar graph which shows bars of data for one variable.
Grouped bar graph which shows bars of data for multiple variables.
Stacked bar graph which shows the contribution of each variable to the total. 
Percentage bar graph which shows the percentage of contribution to the total. 

Latest Posts:

  • Top 10 Essential Microsoft Project Templates for Project Management
  • How to Create a Funnel Chart in Excel? 2 Useful Ways
  • How to Insert a Hyperlink in Excel? 3 Easy Ways
  • A Guide to Jira Issue Types [2022]
  • How to Use CONVERT Function in Excel? A Step-by-Step Guide

Let’s Wrap Up

We are at the end of this guide on bar graphs in Excel. This article explained how to create various types of bar graphs in Excel. I have also shown you how to edit the formatting of any type of bar graph with illustrations. 

If you have any questions regarding bar graphs in Excel or any other Excel feature, please let us know in the comments section below. We at Simon Sez It are always happy to help. 

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advance Excel courses with in-depth training modules

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

Similar Posts

Linking and Unlinking Tasks in Microsoft Project 2016

Automatic Creation of Org Chart Using External Data in Visio 2010 – Part 1

Using the Tell Me Feature in Microsoft Excel 2016

How to Create Charts and Graphs Using Excel 2010

How to Use Photoshop CS6 ? 5 Best Tips for First Time Users

How to Use Microsoft Excel 2016 Options

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)