Looking for ways to know how to create a bar chart in Excel with multiple bars? Then, this is the right place for you. Sometimes, we have to create bar charts with multiple bars containing the data of multiple variables. Here, you will find 3 different ways to create a bar chart in Excel with multiple bars.
Download Practice Workbook
3 Ways to Create a Bar Chart in Excel with Multiple Bars
Here, we will show you how to create a bar chart with multiple bars in Excel in 3 different ways. Go through the steps given below to do it on your own.
1. Using Insert Chart Feature to Create a Bar Chart with Multiple Bars
In the first method, we will show you how to create a bar chart with multiple bars using Insert Chart Feature.
Step-01: Inserting 3-D Clustered Bar Chart
Here, we have a dataset containing the Month, Cost, Selling Price, and Profit of a store. Now, we will show you how to insert a 3-D Clustered Bar Chart in Excel.
Follow the steps given below to do it on your own.
- First, select Cell range B4:E10.
- Then, go to the Insert tab >> click on Insert Bar Chart.
- After that, select 3-D Clustered Bar.
- Finally, you will get a Clustered Bar Chart.
Steps-02: Formatting Bar Chart
Next, We will show you how you can format a bar chart. Go through the steps given below to do it on your own dataset.
- Then, type Sales Analysis as the chart title.
- After that, click on the “+” sign to open Chart Elements.
- Next, turn on Axis Titles.
- Now, click on x Axis Title to change it.
- Then, type Amount as Axis Title.
- After that, click on y Axis Title to change it.
- Next, type Month as Axis Title.
- Finally, you will get your desired bar chart with multiple bars in Excel using Insert Chart Feature.
2. Adding Variables in Existing Bar Chart in Excel
We can also add variables in existing Bar Charts to create a bar chart with multiple bars.
Here, we have a dataset containing the Month, Sales, and Profit of a store. Now, we will show you how to add variables in the existing Bar Chart to create a Bar Chart with multiple bars in Excel.
Follow the steps given below to do it yourself.
Steps:
- First, select Cell range B4:C10.
- Then, go to the Insert tab >> click on Insert Bar Chart >> select 2-D Stacked Bar.
- Now, you will get a Bar Chart like the image given below.
- Next, select the Bar Chart and Right-click.
- After that, click on Select Data.
- Now, the Select Data Source box will open.
- Then, click on Add.
- Next, the Edit Series box will appear.
- After that, select Cell D4 as Series name.
- Then, select Cell range D5:D10 as Series values.
- Now, press OK.
- Again, the Select Data Source box will open.
- Then, press OK.
- Now, you will get a bar chart containing multiple bars.
- After that, add Chart Title and Axis Titles following the steps given in Method 1.
- Finally, you will get your desired Bar Chart with multiple bars by adding variables in the existing bar chart in Excel.
Read More: How to Make a Bar Graph in Excel with 4 Variables (with Easy Steps)
Similar Readings
- How to Make a Simple Bar Graph in Excel (with Easy Steps)
- How to Make a Double Bar Graph in Excel (with Easy Steps)
- Excel Stacked Bar Chart with Subcategories (2 Examples)
- Excel Chart Bar Width Too Thin (2 Quick Solutions)
- How to Change Bar Chart Color Based on Category in Excel (3 Methods)
3. Converting Clustered Column Chart to Clustered Bar Chart with Multiple Bars in Excel
In the final method, we will show you how to convert a Clustered Column chart to Clustered Bar Chart with multiple bars in Excel.
Here, we have a dataset containing the Month and Sales of Texas and Florida of a company. Now, we will show you how to convert a Clustered Column chart to Clustered Bar Chart with multiple bars in Excel using this dataset.
Go through the steps given below to do it on your own dataset.
Steps:
- First, select Cell range B4:D10.
- Then, go to the Insert tab >> click on Insert Bar Chart.
- After that, select the 2-D Clustered Column chart.
- Next, select the Chart and Right-click on it.
- Then, select Change Chart Type.
- Now, the Change Chart Type box will open.
- Afterward, go to the Bar option >> select Clustered Bar.
- Next, press OK.
- Thus, you can convert a Clustered Column chart to Clustered Bar Chart.
- Then, add Chart Title and Axis Titles following the steps given in Method 1 and turn off Gridlines and turn on Legend following the steps given in Method 2.
- Finally, you will get your desired Bar Chart with multiple bars by converting Clustered Column Chart to Clustered Bar Chart.
Read More: How to Create Stacked and Clustered Bar Chart in Excel (with Easy Steps)
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 detailed steps to create a bar chart in Excel with multiple bars. 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 Grouped Bar Chart in Excel (With Easy Steps)
- How to Make a Percentage Bar Graph in Excel (5 Methods)
- What is the Difference Between Bar Graph and Histogram?
- How to Add Vertical Line to Excel Bar Chart (3 Quick Ways)
- How to Sort Bar Chart Without Sorting Data in Excel (with Easy Steps)
- Reverse Legend Order of Stacked Bar Chart in Excel (With Quick Steps)