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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

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

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

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.

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

Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF