Looking for ways to know how to **make a bar graph in Excel** with** 3 variables**? Sometimes, we use **bar graphs** to visualize and compare our dataset more precisely. **Bar graphs** can be used for both** single** and **multiple variables**. Here, you will find step-by-step explained ways to **make a bar graph **in Excel with** 3 variables**.

**Table of Contents**hide

## Download Practice Workbook

## What is Bar Graph?

**Bar Graph** is a graphical representation of some **categorical data** where the **values** of the data are presented by some **rectangular bars**. The **heights** of **rectangular bars** are **proportional** to the **values** of the data. **Bar Charts** can be in two forms: **Horizontal Bar Charts** and **Vertical Bar Charts**.

## 3 Ways to Make a Bar Graph in Excel with 3 Variables

Here, we have a dataset containing the data of **Month**, **Cost**, **Sales** and **Profit** of a shop. Now, we will use this dataset to show you how to **make** a **bar graph** in Excel with **3 variables**.

### 1. Using Bar Chart Option Make a Bar Graph with 3 Variables

In the first method, we will show you how to **make** a **bar graph** with **3 variables** using the **Bar Chart Option**. Go through the steps given below to do it on your own.

**Steps:**

- First, select the Cell range
**B4:E10**. - Then, go to the
**Insert tab**>> from**Charts**>> click on**Bar Chart**.

- After that, select any kind of
**Bar Chart**according to your preference. Here, we will select the**Clustered Column**.

- Next, click on
**Chart Title**to change it.

- Now, type
**Sales Analysis**as**Chart Title**.

- Finally, you will get your desired
**Bar Graph**with**3 Variables**in Excel using**Bar Chart Option**.

**Read More:** **How to Make a Bar Graph in Excel with 4 Variables (with Easy Steps)**

### 2. Adding a Variable to Bar Graph with 2 Variables in Excel

We can also **make** a **bar graph** with **3 variables** by **adding** an extra **variable** with a **2 variable bar graph**. Follow the steps given below to do it with our own dataset.

**Steps:**

- In the beginning, select the Cell range
**B4:D10**. - After that, go to the
**Insert tab**>> from**Charts**>> click on**Bar Chart**.

- Then, select any kind of
**Bar Chart**according to your preference. Here, we will select the**Clustered Column**.

- Now, click on
**Chart Title**to change it.

- Next, type
**Sales Analysis**as**Chart Title**.

- Afterward,
**Right click**on the chart. - Then, click on
**Select Data**.

- Afterward, the
**Select Data Source**box will open. - Next, click on the
**Add**button.

- Then, the
**Edit Series**box will open. - After that, select Cell
**E4**in the**Series name**box. - Next, select Cell range
**E5:E10**in the**Series values**box. - Finally, press
**OK**.

- Now, you can see that
**Profit**data have been added in the chart data. - Then, press
**OK**.

- Finally, you will get your desired
**Bar Graph**with**3 variables**by**adding**an extra**variable**with a**bar graph**with**2 variables**.

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

**Similar Readings**

**How to Show Difference Between Two Series in Excel Bar Chart (2 Ways)****How to Make a Bar Graph with Multiple Variables in Excel****What is the Difference Between Bar Graph and Histogram?****How to Make a Grouped Bar Chart in Excel (With Easy Steps)****Excel Bar Graph Color with Conditional Formatting (3 Suitable Examples)**

### 3. Use of Pivot Chart to Make a Bar Graph in Excel with 3 Variables

In the final method, we will use the **Pivot Chart** to **make** a **bar graph** with** 3 variables**. **Pivot Charts** are normally used to quickly summarize data and give an easy-to-understand visual representation.

Follow the steps given below to do it on your own.

**Steps:**

- First, select the Cell range
**B4:E10**. - Then, go to the
**Insert tab**>> click on**Pivot Chart**>> select**Pivot Chart**Option.

- Now, the
**Create PivotChart**box will appear. - Next, you can see that the data table has been selected in the
**Select a table or range**. - Then, select
**New Worksheet**. - After that, press
**OK**.

- Now, the
**PivotChart Fields**toolbox will appear. - Afterward, insert the
**Month**column into the**Axis**box.

- Then, insert the
**Cost**,**Sales**,**Profit**columns into the**Values**box.

- Finally, you will get your desired
**Bar Graph**with**3 Variables**in Excel using**Pivot Chart**.

**Read More:** **How to Plot Stacked Bar Chart from Excel Pivot Table (2 Examples)**

## Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

## Conclusion

So, in this article, you will find a step-by-step way to **make a bar graph **in Excel with** 3 variables**. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit **ExcelDemy** for many more articles like this. Thank you!

**Related Articles**

**How to Make a Bar Graph in Excel without Numbers****How to Change Bar Chart Color Based on Category in Excel (3 Methods)****Excel Chart Bar Width Too Thin (2 Quick Solutions)****How to Make a Diverging Stacked Bar Chart in Excel (with Easy Steps)****How to Show Variance in Excel Bar Chart (with Easy Steps)****Excel Stacked Bar Chart with Subcategories (2 Examples)**