QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Make Bar Graph in Excel?

By Neha T Leave a Comment

The bar graph in Excel is one of the easiest ways to present data graphically. It not only makes your data presentable but is also helpful in engaging your audience. Bar graph presents the data with rectangular horizontal bars. The length of the bar depends on the data values.

In this context we will be discussing the steps to make:

  1. Simple Bar Graph
  2. Bar Graph with 2 Variables
  3. Bar Graph with 3 Variables
  4. Stacked Bar Graph

Steps to Make Bar Graph in Excel:

Simple Bar Graph

To make a simple graph we must have values for at least two categories that we have to compare. In the example below we have values for two categories are ‘Fruits’ & ‘Quantity’.

First, we have to select the values for two categories as you can see in the image below. Now from the Insert tab, in the Charts group, you have to click on the ‘Insert Column or Bar Chart’ drop-down button.

Make a Bar Graph in Excel-1

Here you can select the kind of bar chart you want to present your data.

Make a Bar Graph in Excel-2

As you can see in the image below by default the first column of the selected data is taken as the x-axis and the second column is considered as the y-axis.

Make a Bar Graph in Excel-3

  • Chart Elements
    To format or edit the elements of the bar chart when you click to select the bar chart it will allow you to select or deselect the element of the bar chart like Axes, Axis Titles, Chart Titles, etc.
    Make a Bar Graph in Excel-4
  • Chart Style
    To improve the style of the bar chart you have selected the chart and clicked on the Style| Color button. And here you can improve the appearance of your bar chart.
    Make a Bar Graph in Excel-5
  • Chart Filter
    The bar chart also allows you to select what data points and names are visible on your chart.
    Make a Bar Graph in Excel-6

Bar Graph with 2 Variables

To make a bar graph with two variables we must have two categories that we have to compare against only one category. This means there is one variable on the x-axis and two variables on the y-axis.

As you can see in the image below, we have the ‘Fruits’ variable on the x-axis and the quantity of fruits in the ‘Mkt 1’, ‘Mkt 2’ variable.

Make a Bar Graph in Excel-7

Bar Graph with 3 Variables

To make a bar graph with three variables we must have three categories that we have to compare against only one category. This means there is one variable on the x-axis and three variables on the y-axis.

As you can see in the image below, we have the ‘Fruits’ variable on the x-axis and the quantity of fruits in the ‘Mkt 1’, ‘Mkt 2’, ‘Mkt 3’ variables.

Make a Bar Graph in Excel-09

Stacked Bar Graph

The stacked bar graph is one where the variables of the y-axis are stacked on top of each other. Because of this, the height of each stack bar represents the total of all series in that category.

You will get the option of stack bar from the ‘Insert Column or Bar Chart’ button in the ‘Charts’ group of the ‘Insert’ tab.

Make a Bar Graph in Excel-08

The stack bar chart in the image below shows the values of the series ‘Mkt 1’and ‘Mkt 2’ stacked on top of each other for each element of the Fruit category.

Make a Bar Graph in Excel-8

So, this is how you can make a bar graph in Excel. We have seen different kinds of bar graphs in our content. Still, this is not a limit in Excel you can explore more to understand charts better.

You Might Also Like:

Graph in Excel - featured ImageHow to Create a Graph in Excel? Pie Chart in Excel featured ImageHow Create a Pie Chart in Excel? Create a Bell Curve in Excel - feature image 1How to Create a Bell Curve in Excel? Create Pivot Table in Excel feature imageHow to Create a Pivot Table in Excel? Count Duplicate Value in Excel -Featured ImageHow to Count Duplicate Values in Excel? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to add screensavers in Ubuntu 14.04
  • How to change Microsoft Word theme
  • How to change your password in Snapdeal
  • How to Add or Remove programs in Ubuntu 14.04
  • How to install gmail offline app

Copyright © 2023 · QueHow · Contact Us