How to Make Multi Category or Subcategory Chart in Excel

Multi category charts or multi-level category charts are chart types with primary axis divided into multiple categories or subcategories. Such chart types help in visualizing data by dividing each item into different categories within an Excel chart.
In this Excel tutorial, we will learn how to create a multi-category chart in Excel in easy to follow step by step approach.
In addition to making multi-level category charts by dividing the primary axis into different categories, we will learn some cool tips to speed up the charting process and also to make this chart even better.
Like | Follow:
Fb: / learnexceltoexcel
Tw: / exceltoexcel
Pin: / pakaccountants
!! Get FREE Excel CORE BOOK:
pakaccountants.com/excel-core...
[] For more Excel lessons and tutorials visit: pakaccountants.com/excel/
#MSExcel #ExcelCharts #MultiCategoryChart

[@jameswalker9024]

why don't you show how to actually set up the data first. I like how your format. but how to set it up i don't know how

[@adriradzman4867]

how to make the subcategory text horizontal?

[@missadventure7564]

thank you, so helpful. how do you automate this type of chart?

[@HasaanFazal]

Appreciate your kind words. What aspect would you like to automate?

[@missadventure7564]

@@HasaanFazal automating multi category chart. For example, in your case, you have years of data. But If I wanted to update every month with new data and I wanted to delete previous month as I 'm adding new data - how do I automate that. Lets in your case, you are going to add a new year data and you wanted to delete previous year of data from the chart - and how would you automate that?
I know how to automate the new data but not able to figure out how to delete the previous data (for month or year), If I delete previous month data from automated table it disappears from table and graph but, in the chart I see the deleted data space.

[@sarthakpatelia9888]

can you give us business category and sub category lists