EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Functions Excel Bar Chart
Secondary Sidebar
Excel Functions
  • Excel Functions
    • Excel Column Total
    • VLOOKUP to Return Multiple Values
    • User Defined Function in Excel
    • Excel SWITCH Function
    • Excel FV Formula
    • Excel AVERAGEIF
    • Simple Formula in Excel
    • Excel Scatter Chart
    • Excel Bar Chart
    • LINEST Excel Function
    • RANK Excel Function
    • Excel MOD Function
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Certification Course
  • EXCEL Certification COURSE

Excel Bar Chart

By Jeevan A YJeevan A Y

Bar Chart in Excel

Bar Chart in Excel (Table of Contents)

  • Introduction to Bar Chart in Excel
  • How to Create a Bar CHART in Excel?

Introduction to Bar Chart in Excel

Bar Chart in Excel is one of the easiest types of the chart to prepare by just selecting the parameters and values available against them. We must have at least one value for each parameter. Bar Chart is shown horizontally, keeping their base of the bars at Y-Axis. Bar Chart can be accessed from the insert menu tab from the Charts section, which has different types of Bar Charts such as Clustered Bar, Stacked Bar and 100% Stacked Bars available in 2D and 3D types.

In this article, I will take you through the process of creating Bar Charts.

How to Create Bar Chart in Excel?

Bar Chart in Excel is very simple and easy to create. Let us understand the working of the Bar Chart in Excel by Some Examples.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,497 ratings)
You can download this Bar Chart Excel Template here – Bar Chart Excel Template

Example #1

Take a simple piece of data to present the bar graph. I have sales data for 4 different regions East, West, South, and North.

BAR chart Example 1

Step 1: Select the data.

BAR chart Example 1-1

Step 2: Go to insert and click on Bar chart and select the first chart.

BAR chart Example 1-2

Step 3: once you click on the chart, it will insert the chart as shown in the below image.

BAR chart Example 1-3

Step 4: Remove gridlines. Select the chart go to layout > gridlines > primary vertical gridlines > none.

BAR chart Example 1-4

Step 5: select the bar, right-click on the bar, and select format data series.

BAR chart Example 1-5

Step 6: Go to fill and select Vary Colours by Point.

BAR chart Example 1-6

Step 7: Moreover, we can make the bar colors look attractive by right click on each bar separately.

Right, click on the first bar > go to Fill > Gradient Fill and apply the below format.

BAR chart Example 1-7

Step 8: To give the Chart Heading, go to layout>Chart Title > Select Above chart.

BAR chart Example 1-8

Chart Heading will be displayed as here it is Sales by Region.

BAR chart Example 1-9

Step 9: To add Labels to the bar Right click on bar > Add Data Labels; click on it.

BAR chart Example 1-10

Data Label is added to each bar.

BAR chart Example 1-11

Similarly, you can choose different colors for each bar separately. I have chosen different colors, and my chart is looking like this.

BAR chart Example 1-12

Example #2

There are multiple bar graphs available. In this example, I am going to use the CONE type of bar chart.

I have sales data from Jan to Dec. To present the data to the management to review the sales trend, I am applying a bar chart to visualize and present better.

BAR chart Example 2

Step 1: Select the data > Go to Insert > Bar Chart > Cone Chart

BAR chart Example 2-1

Step 2: Click on the CONE chart, and it will insert the basic chart for you.

BAR chart Example 2-2

Step 3: Now, we need to modify the chart by changing its default settings.

Remove gridlines of the above Chart.

BAR chart Example 2-3

Change the chart title to Sales by month.

BAR chart Example 2-4

Remove Legends from the chart and enlarge to make visible all months vertically.

BAR chart Example 2-5

Step 4: Select each cone separately and filled with beautiful colors. After all the modifications, my chart looks likes this.

BAR chart Example 2-6

For the same data, I have applied different bar chat types.

Cylinder Chart:

BRC Example 2-7

Pyramid Chart:

BRC Example 2-8 

Example #3

In this example, I am going to use a stacked bar chart. This chart tells the story of two series of data in a single bar.

Step1: Set up the data first. I have the commission data for a sales team, which has been separated into two sections. One is for the first half-year, and another one is for the second half of the year.

BRC Example 3-1

Step 2: Select the data > Go to Insert > Bar > Stacked bar in 3D.

BRC Example 3-2 

Step 3: Once you click on that chat type, it will instantly create a chart for you.

BRC Example 3-3

Step 4: Modify each bar color by following the previous example steps.

BRC Example 3-4

Step 5: Change the number format to adjust the spacing. Select the X-Axis and right-click > Format Axis.

BRC Example 3-5

Step 6: Go to Number > Custom > Apply this code [>999.5]#,##0,”k”;#,##0.

This will format the lakhs into thousands. For example, format the 1, 00,000 as 100K.

BRC Example 3-6

Step 7: Finally, my chart looks like this.

BRC Example 3-7

Advantages of Bar Chart in Excel:

  • Easy comparison with better understanding.
  • Quickly find the growth or decline.
  • Summarize of the table data into visuals.
  • Make quick planning and take decisions.

Disadvantages of Bar Chart in Excel:

  • Not suitable for a large amount of data.
  • Do not tell many assumptions associated with the data.

Things to Remember

  • Data arrangement is very important here. IF the data is not in a suitable format, then we cannot apply a bar chart.
  • Choose a bar chart for a small amount of data.
  • Any non-numerical value is ignored by the bar chart.
  • Column and bar charts are similar in terms of presenting the visuals, but the vertical and horizontal axis is interchanged.

Recommended Articles

This has been a guide to a BAR chart in Excel. Here we discuss its uses and how to create Bar Chart in Excel with excel examples and downloadable excel templates. You may also look at these useful functions in excel –

  1. Grouped Bar Chart
  2. Excel Stacked Bar Chart
  3. Excel Clustered Bar Chart
  4. Free Excel Template
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Bar Chart Excel Template

EDUCBA

Download Bar Chart Excel Template

EDUCBA

डाउनलोड Bar Chart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more