How to Create a Bar Chart in Excel with Multiple Bars (3 Ways)

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.

Watch Video – Create a Bar Chart 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.

In the beginning, click on the Chart Title box to change the chart title.

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.

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.

Next, click on the “+” sign to open Chart Elements.
Then, turn off Gridlines and turn on Legend.

Finally, you will get your desired Bar Chart with multiple bars by adding variables to the existing bar chart 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.

Practice Section

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

Download Practice Workbook

Creating Bar Chart with Multiple Bars

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!

<< Go Back to Create a Bar Chart in Excel | Excel Bar Chart | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!