How to Create Bar Chart with Multiple Categories in Excel

Get FREE Advanced Excel Exercises with Solutions!

Bar chart is an excellent option for visual representation of data in Excel. And it’s possible to create a bar chart with multiple categories in Excel. If we have items in the dataset that can be arranged in category and sub-category, then we can use multi-level bar chart. In this article, we will discuss step-by-step procedures to create bar chart with multiple categories.


Download Practice Workbook

You can download the practice workbook from here.


Step-by-Step Procedures to Create Bar Chart with Multiple Categories in Excel

It’s quite simple to make the bar chart in Excel with multiple categories. Here, we will discuss the steps to create a bar chart that includes categories and subcategories. Then we will do some additional formatting to the chart for better clarification and visualization.


STEP 1: Create Dataset for Bar Chart with Multiple Categories

  • Firstly, create a dataset for the bar chart that included categories, sub-categories and items in three separate columns.
  • For example, we have included category column Product Type, sub-categories column Product and items column Quantity.

excel bar chart with multiple categories

Note: Leave 2 blank rows in between each category and insert a space in the first empty cell of the blank row for better visualization of the chart.

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


STEP 2: Create Bar Chart Using Insert Tab of Excel

  • Secondly, select the whole dataset for creating bar chart with it.

Create Bar Chart Using Insert Tab of Excel

  • Then, go to the Insert tab and select Insert Column or Bar Chart > 2-D Bar > Clustered Bar.

  • Instantly, we will see a bar chart with multiple categories created in our worksheet.
  • Further, you can double-click on the chart title and give it a name.

Read More: How to Create Stacked and Clustered Bar Chart in Excel (with Easy Steps)


STEP 3: Give Different Colors to Bar Chart

All the bars from different categories are of the same color in our bar chart. Let’s change that.

  • Firstly, click on the chart. It will select all the chart items.
  • Again, click on a single item and it will be selected like in the screenshot given below.

Give Different Colors to Bar Chart

  • Afterward, go to the Format tab and select a color from Shape Fill option.

  • Also, do the same steps for giving different colors to items from different categories.

excel bar chart with multiple categories output

Read More: How to Color Bar Chart by Category in Excel (2 Easy Methods)


Similar Readings


STEP 4: Do Some Additional Formatting

So far we have created the basic bar chart with multiple categories. Let’s do some formatting on it for better visualization. For that follow the procedures given below.

  • Firstly, select the bar chart.
  • Then, from the upper right corner of the chart select Chart Elements.
  • Now, select Data Labels. It will attach data labels to the chart elements.
  • Also, unselect Gridlines and the gridlines from the graph will vanish.

Do Some Additional Formatting

  • Afterward, double-click on the chart.
  • Instantly, Format Chart Area pane will appear.
  • Later on, select Border from the pane. You can choose the borderline type from here.
  • We selected Solid Line. Also, you can choose different colors and line widths for the border line from this section.

Read More: Excel Bar Graph Color with Conditional Formatting (3 Suitable Examples)


Final Output

After following all the previous steps given, we will get the bar chart graph with multiple categories like the following screenshot.

excel bar chart with multiple categories final output

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


How to Convert Bar Chart to Column Chart in Excel

In the previous section, we have created a bar chart with multiple categories. We can easily convert it to a column chart with multiple categories.

How to Convert Bar Chart to Column Chart in Excel

Follow the given steps below for converting a bar chart to a column chart.

  • Primarily, create a bar chart following the steps given in the previous section.
  • Then, right-click on the bar chart.
  • Afterward, from the appeared lists select Change Chart Type.

  • Instantly, Change Chart Type window will appear.
  • Select Column > Clustered Column from the window.
  • Finally, press OK.

  • As a result, we will see our bar chart converted to a column chart with multiple categories like in the screenshot given below.

Read More: How to Create a 3D Bar Chart in Excel (3 Suitable Examples)


Conclusion

In this article, we have shown step-by-step procedures to create a bar chart with multiple categories. I hope, you will find it helpful. If you have any queries or suggestions about the article, please let us know in the comment section. For similar articles regarding Excel problems, visit our ExcelDemy Website.


Related Articles

Mehedi Hasan Shimul
Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo