ExcelTutorials

Learn How to Create a Horizontal Bar Chart in Excel

1 Mins read

A horizontal bar chart may look appealing, but to make it may be troublesome. In this article, we going to learn how to create a Horizontal Bar Chart in Excel with 5 easy steps.

  • Consider there are two tables i.e. Income and Expense
    • Select the data with headers and Press Ctrl + T. Do it for both Income and Expense.

Excel Vlookup formula – Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

How to Create a Horizontal Bar Chart in Excel

Follow the below steps to create a Horizontal Bar Chart in Excel

1. You need to give the table a Name. To do so follow these steps:

  • Click on any cell in the table.
  • Go to Table Tools in Ribbon then Click on the Design tab
  • Type the name for Table for future reference to create the horizontal bar chart. Check the below image for reference
  •  

2. Go to Formula tab
3. Click on Name Manger
4. Click on New Button
5. Give it a name and formula. Refer to the image below.

excel-monthly-income

1. Now you need to create a formula in Name Manger under Formula Tab. Here are the steps to do that:

2. Preparation work done, here are the final steps to make percentage bar chart:

  1. Select a cell on a worksheet where you want the horizontal bar chart to be placed
  2. Type =TotalMonthlyExpenses in the selected cell
  3. Go to Conditional Formatting tab, click on Manage Rules.

1. Create a New Rule

2. Fill all the details as mentioned below (Refer below image for more clarity.)

  • i.Select the Rule Type as Format all cells based on their values

1. In Edit the Rule Description section:

  • Select Data Bar in Format Style dropdown
  • Tick box for show Bar only to hide values displayed in Bar
  • Select Type as Number for Minimum and Maximum columns
  • For Value, Select 0 for Minimum and write formula =TotalMonthlyIncome for Maximum
  • For Bar Appearance, select a fill color and border as per your preference.
  • Click Ok to complete the process.

2. To get the percentage on right side, write this formula =TotalMonthlyExpenses/TotalMonthlyIncome in the cell next to bar chart.

15 Pivot Tables Tricks for Pros

15 Pivot Table tricks to make your Excel data analysis smarter! 5,600+ downloads.

Most Popular Tricks are #3, #7 & #12

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…