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.


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.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars

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.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars


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.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars

  • Then, type Sales Analysis as the chart title.

  • After that, click on the “+” sign to open Chart Elements.
  • Next, turn on Axis Titles.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars

  • Now, click on x Axis Title to change it.

  • Then, type Amount as Axis Title.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars

  • After that, click on y Axis Title to change it.

  • Next, type Month as Axis Title.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars

  • Finally, you will get your desired bar chart with multiple bars in Excel using Insert Chart Feature.

Using Insert Chart Feature to Create a Bar chart with Multiple Bars


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.

Adding Variables in Existing Bar Chart 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.

Adding Variables in Existing Bar Chart in Excel

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

Adding Variables in Existing Bar Chart in Excel

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

Adding Variables in Existing Bar Chart in Excel

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

Adding Variables in Existing Bar Chart in Excel

  • Finally, you will get your desired Bar Chart with multiple bars by adding variables in the existing bar chart in Excel.

Adding Variables in Existing Bar Chart in Excel

Read More: How to Make a Bar Graph in Excel with 4 Variables (with Easy Steps)


Similar Readings


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.

Converting Clustered Column Chart to Clustered Bar Chart with Multiple Bars in Excel

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.

Converting Clustered Column Chart to Clustered Bar Chart with Multiple Bars in Excel

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

Converting Clustered Column Chart to Clustered Bar Chart with Multiple Bars in Excel

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

Converting Clustered Column Chart to Clustered Bar Chart with Multiple Bars in Excel

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.

Practice Section


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

Arin Islam

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

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo