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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

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

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 the 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 the Insert Chart Feature.

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

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.

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

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 to the existing bar chart in Excel.

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

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

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

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.

Practice Section


Download Practice Workbook


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!


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo