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**.

**Table of Contents**hide

## 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**.

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.

- 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**.

**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**.

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 from**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.

**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.

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 **PivotTable** 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**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**.

**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.

## 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

**How to Refresh Pivot Chart in Excel (4 Suitable Approaches)****How to Insert a Stacked Column Pivot Chart in Excel****How to Add Target Line to Pivot Chart in Excel (2 Effective Methods)****Difference Between Pivot Table and Pivot Chart in Excel****How to Filter a Pivot Chart in Excel (5 Suitable Ways)****Types of Pivot Charts in Excel (7 Most Popular)**