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.
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 graphs. One is Horizontal and they are 2-D/ 3-D bars. Another is Vertical and they are 2-D/ 3-D Columns.
Moreover, there are other deviations for both types. They are a Clustered Bar, a Stacked Bar, and a 100% Stacked Bar.
How to Make a Bar Graph in Excel with 2 Variables: 3 Methods
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 the Bar Charts Feature to make a bar graph with 2 variables. The steps are given below.
- Firstly, you have to select the data. Here, I have selected the range B4:D9.
- Secondly, open the Insert tab.
- 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.
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.
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.
- Here, I have used the range B4:C9 for making the bar chart with 1 variable.
- By following 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.
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.
- 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.
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 B5:B9.
- Now, press OK to make the changes.
- After this, press OK on the Select Data Source box.
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.
After changing the Chart Title and Axis Title, you will see the following bar graph with added variables.
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.
- 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 the B12 cell.
- Finally, you must click on OK to get the changes.
At this time, you will see the following output.
- Now, in PivotChart Fields, you have to drag Product to Axis (Categories).
- Similarly, drag Sales and Profit to the Values.
Finally, your PivotTable and PivotChart are done. You will see the Pivot Table below.
In addition, the PivotChart is given below.
- Now, you have to Right-Click on PivotChart to change the chart style.
- Then, from the Context Menu Bar >> you must select the Change Chart Type option.
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.
Things to Remember
- For both 1st and 2nd methods, you can choose different types of Bar Charts.
- In the 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.
Now, you can practice the explained method by yourself.
Download Practice Workbook
You can download the practice workbook from here:
I hope you found this article helpful. Here, I have explained 3 different ways to Make a Bar Graph in Excel with 2 Variables. Please, drop comments, suggestions, or queries if you have any in the comment section below.
- How to Make a Bar Graph Comparing Two Sets of Data in Excel
- How to Make a Percentage Bar Graph in Excel
- How to Show Number and Percentage in Excel Bar Chart
- How to Show Difference Between Two Series in Excel Bar Chart
- Excel Bar Chart Side by Side with Secondary Axis
- How to Sort Bar Chart Without Sorting Data in Excel
- How to Change Bar Chart Width Based on Data in Excel