Arin Islam
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.
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)
