How to Make a Bar Graph in Excel with 2 Variables (3 Easy Ways)

Sometimes for data visualization, you may need to make a bar graph. A bar chart is an important thing in our daily life. We can visualize the situation easily with bar charts. In this article, I will explain how to make a bar graph in Excel with 2 variables.


Download Practice Workbook

You can download the practice workbook from here:


What Is a Bar Graph?

A bar graph is a method of representing data with rectangular bars, the height of the rectangle denotes the numerical values of data. You can visualize data with the height of rectangles.


Types of Bar Graph in Excel

There are two types of bar graph. One is Horizontal and they are 2-D/ 3-D Bar. Another is Vertical and they are 2-D/ 3-D Column.

how to make a bar graph in excel with 2 variables

Moreover, there are other deviations for both types. They are Clustered Bar, Stacked Bar, and 100% Stacked Bar.


3 Methods to Make a Bar Graph in Excel with 2 Variables

Here, I will describe 3 methods to make a bar graph in Excel with 2 variables. In addition, for your better understanding, I’m going to use a sample dataset. Which contains  3 columns. They are Product, Sales, and Profit. The dataset is given below.


1. Using Bar Chart Feature to Make a Bar Graph with 2 Variables

There is a built-in process in Excel for making bar charts under the Charts group Feature. In addition, you can use Bar Charts Feature to make a bar graph with 2 variables. The steps are given below.

Steps:

  • Firstly, you have to select the data. Here, I have selected the range B4:D9.
  • Secondly, open the Insert tab.

how to make a bar graph in excel with 2 variables

  • Now, from the Charts group section, you have to select Insert Column or Bar Chart.
  • Then, I have chosen from 2-D Bar >> Clustered Bar. Here, the selection will be according to your preference.

Now, you will see the result by clicking the 2-D Clustered Bar feature.

how to make a bar graph in excel with 2 variables

Now, you can add the Data Labels from the Chart Elements section. Apart from this, you can change the Chart Title.

Finally, you can see the following bar graph with 2 variables.

how to make a bar graph in excel with 2 variables

Read More: How to Make a Line Graph in Excel with Multiple Lines (4 Easy Ways)


2. Use of Context Menu Bar to Add a New Variable in Bar Graph

You can employ the Context Menu Bar to add a new bar to an existing chart in Excel. In addition, Let you have the following data set and the corresponding bar chart with 1 variable.

Steps:

  • Here, I have used the range B4:C9 for making the bar chart with 1 variable.
  • By following the Method-1, I have made the bar chart with 1 variable.

Now, you want to add a new bar with the data for Profit.

  • Firstly, you must Right-Click on the chart.
  • Secondly, from the Context Menu Bar >> you need to choose Select Data.

how to make a bar graph in excel with 2 variables

After that, you will see the following dialog box of Select Data Source.

  • Now, from the dialog box of Select Data Source, you have to choose the Add feature.

After selecting the Add feature, another dialog box of Edit Series will appear.

how to make a bar graph in excel with 2 variables

  • Now, you can write down or select the Series name in that dialog box. Here, I have selected the Series name as Profit from the D4 cell.
  • Then, you have to include the Series values. Here, I have used the range D5:D9.
  • Finally, you need to press OK to get the corresponding bar chart.

Subsequently, the previous dialog box of Select Data Source will appear.

  • Now, from this, you may click on the Edit option to change the Axis Labels.

how to make a bar graph in excel with 2 variables

At this time, a dialog box named Axis Labels will appear.

  • Then, you have to select the Axis label range. Here, I have selected the range from B5:B9.
  • Now, press OK to make the changes.

  • After this, press OK on the Select Data Source box.

how to make a bar graph in excel with 2 variables

Finally, you will see the following bar chart with 2 variables.

Now, you can change the Chart Title by clicking on it. Similarly, you can do it for Axis Title.

how to make a bar graph in excel with 2 variables

After changing the Chart Title and Axis Title, you will see the following bar graph with added variables.

Read More: How to Edit Pivot Chart in Excel (with Easy Steps)


3. Employing Excel Pivot Chart Options to Make a Bar Graph with 2 Variables

To make a bar chart in Excel with 2 variables, you can use Pivot Chart. The steps are given below.

Steps:

  • Firstly, you have to select the data range with which you want to make a bar graph. Here, I have selected the range B4:D9.
  • Secondly, you must go to the Insert tab.
  • Thirdly, from PivotChart >> you need to choose PivotChart.

Now, a dialog box named Create PivotChart will appear.

  • From the dialog box firstly, you have to select Table/Range. Which will be auto-selected here.
  • Secondly, you may click on the Existing Worksheet under the choose where you want the PivotChart to be placed option.
  • Thirdly, you have to choose the Location. Here, I have chosen the new Location as B12 cell.
  • Finally, you must click on OK to get the changes.

how to make a bar graph in excel with 2 variables

At this time, you will see the following output.

  • Now, in PivotChart Fields, you have to drag Product to Axis (Categories).

how to make a bar graph in excel with 2 variables

  • Similarly, drag Sales and Profit to the Values.

Finally, your PivotTable and PivotChart are done. You will see the PivotTable below.

In addition, the PivotChart is given below.

how to make a bar graph in excel with 2 variables

  • Now, you have to Right-Click on PivotChart to change the chart style.
  • Then, from the Context Menu Bar >> you must select Change Chart Type option.

how to make a bar graph in excel with 2 variables

At this time, a new dialog box named Change Chart Type will appear.

  • Now, from Bar >> you have to select Clustered Bar.
  • Finally, you need to click on OK.

Lastly, you will see the following bar graph with 2 variables.how to make a bar graph in excel with 2 variables

Read More: How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart


Things to Remember

  • For both 1st and 2nd methods, you can choose different types of Bar Charts.
  • In case of the 3rd method, PivotTable will be auto-generated. Furthermore, the bar graph will be in 2-D Column Clustered Column form. Also, you can change this formation as per your preference.

Practice Section

Now, you can practice the explained method by yourself.

how to make a bar graph in excel with 2 variables


Conclusion

I hope you found this article helpful. Here, I have explained 3 different ways to Make a Bar Graph in Excel with 2 Variables. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Musiha
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo