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.
How to Create a Bar Chart in Excel with Multiple Bars: 3 Ways
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 the 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 the 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 the Insert Chart Feature.
Read More: How to Make a Simple Bar Graph in Excel
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 the 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 to the existing bar chart in Excel.
Read More: How to Make a Double Bar Graph in Excel
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 a 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 a 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 a Clustered Bar Chart.
- Then, add Chart Title and Axis Titles following the steps given in Method 1, 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 the Clustered Column Chart to the Clustered Bar Chart.
Read More: How to Create Clustered Stacked Bar Chart in Excel
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. Thank you!