WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Bar Chart in Excel

Bar Chart in Excel

Excel Bar Chart

Bar charts in excel are useful in the representation of the single data on the horizontal bar. They represent the values in horizontal bars. In these charts, categories are displayed on the Y-axis and values are displayed on the X-axis. To create or make a bar chart, a user needs at least two variables called independent and dependent variables.

Independent Variable: This doesn’t change with respect to any other variable.

Dependent Variable: This change with respect to the independent variable.

Mainly there are three types of bar charts in excel.

  • #1 – Stacked Bar Chart: It is also referred to as the segmented chart. It represents all the dependent variables by stacking together and top of other variables.
  • #2 – Clustered Bar Chart: This chart groups all the dependent variables together to display in a graph format. A clustered chart with two dependent variables is referred to as the double graph.
  • #3 – 3D Bar Chart: This chart represents all the dependent variables in 3D representation.

Excel Bar Chart

Examples to Create Various Types of Bar Chart in Excel

You can download this Bar Chart Excel Template here – Bar Chart Excel Template

Example #1 – Stacked Bar Chart

This example is to illustrates how to create a stacked bar graph in simple steps.

  • Step 1: Enter the data into the excel sheets in the table format, as shown in the figure.

Bar Chart in Excel Example 1

  • Step 2: Select the entire table by clicking and dragging or placing the cursor anywhere in the table and pressing CTRL+A to select the entire table.

Example 1.1

  • Step 3: Go to the “Insert” tab and move the cursor to the insert bar chart option.

Bar Chart in Excel Example 1.2

  • Step 4: Under the 2D bar chart, select the stacked bar chart, as shown in the below-mentioned figure.

Example 1.3

  • Step 5: The stacked bar chart will be displayed, as shown below.

Bar Chart in Excel Example 1.4

  • Step 6: Add “Data Labels” to the data series in the plotted area.

To do this, click on the chart area to select the data series.

Example 1.5

  • Step 7: Right-click on the data series and choose the add data labels to add the data label option, as shown in the screenshot.

Bar Chart in Excel Example 1.6

The data is added to the plotted chart, as shown in the figure.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1.7

  • Step 8: We can move the bar chart to the desired place in the worksheet, click on edge, and drag it with the mouse.

Bar Chart in Excel Example 1.8

  • Step 9: We can change the design of the bar chart utilizing the various options available, including change color, change the chart type, and moving the chart from one sheet to another sheet.

Example 1.9

We get the following stacked bar chart.

Bar Chart in Excel Example 1.10

We can use the “Format Chart Area” to change color, transparency, dash type, cap type, and join type.

Example 1.12

Example #2 – Clustered Bar Chart

This example is to illustrate how to create a clustered bar chart in simple steps.

  • Step 1: Enter the data into the excel sheets in the excel table format, as shown in the figure.

Bar Chart in Excel Example 2

  • Step 2: Select the entire table by clicking and dragging or placing the cursor anywhere in the table and pressing CTRL+A to select the entire table.

Example 2.1

  • Step 3: Go to the “Insert” tab and move the cursor to the insert bar chart option, and under the 2D bar chart, select the clustered bar chart as shown in the below mentioned figure.

Bar Chart in Excel Example 2.2

  • Step 4: Add a suitable title to the chart, as shown in the figure.

Example 2.3

  • Step 5: Right-click on the data series and choose the add data labels to add the data label option, as shown in the screenshot.

Bar Chart in Excel Example 2.4

The data is added to the plotted chart, as shown in the figure.

Example 2.5

  • Step 6: Apply formatting to change the design of the charts using the “Design” and “Format” tabs of the chart, as shown in the figure.

Bar Chart in Excel Example 2.8

We get the following chart.

Example 2.6

We can also change the layout of the chart using the “Quick Layout” feature.

Bar Chart in Excel Example 2.9

We get the following clustered bar chart.

Example 2.7

Example #3 – 3D Bar Chart

This example is to illustrate how to create a 3d bar chart in excel in simple steps.

  • Step 1: Enter the data into the excel sheets in the table format, as shown in the figure.

Bar Chart in Excel Example 3

  • Step 2: Select the entire table by clicking and dragging or placing the cursor anywhere in the table and pressing CTRL+A to select the entire table.

Example 3.1

  • Step 3: Go to the “Insert” tab and move the cursor to the insert bar chart option, and under the 3D bar chart, select the 100% full stacked bar chart, as shown in the below mentioned figure.

Bar Chart in Excel Example 3.2

  • Step 4: Add a suitable title to the chart, as shown in the figure.

Example 3.3

  • Step 5: Right-click on the data series and choose the add data labels to add the data label option, as shown in the screenshot.

Bar Chart in Excel Example 3.5

The data is added to the plotted chart, as shown in the figure.

Example 3.6

Apply the required formatting and design to the chart using the format chart area. We get the following 3D Bar chart.

Bar Chart in Excel Example 3.7

Uses of Bar Chart

The bar chart in excel is used for different purposes, including.

  • Easier planning and making decisions based on the data analyzed.
  • Determination of business decline or growth in a short time from the past data.
  • Visual representation of the data and improved abilities in the communication of difficult data.
  • Comparing the different categories of data to enhance the proper understanding of it.
  • Summarizing the data in the graphical format produced into the tables.

Things to Remember

  • A bar chart is only useful for small sets of data.
  • The bar chart ignores the data if it contains non-numerical values.
  • It is hard to use the bar charts if data is not arranged properly in the excel sheet.
  • Bar chart and column charts have a lot of similarities except visual representation of the bars in horizontal and vertical format. These can be interchanged with each other.

Recommended Articles

This has been a guide to bar chart in excel. Here we discuss how to create different types of bar charts (stacked, clustered, and 3d) along with practical examples and downloadable excel templates. You can have a look at other articles on excel functions –

  • Stock Chart in Excel
  • Create Control Charts in Excel
  • Create Excel Combo Chart
  • Make Dot Plots in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download Bar Chart Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More