This article is about creating a Multicategory chart in Excel. For creating a multicategory chart in Excel the data should be arranged in either of two formats shown below.

For Creating a Multicategory Column chart,
Select the whole data (A1:C13)
Click on Insert Tab
Click on the Icon for Column/Bar chart present in the Group for charts
Select the Clustered Column from the available options

For Creating a Multicategory Bar chart,
Select the whole data (A1:C13)
Click on Insert Tab
Click on the Icon for Column/Bar chart present in the Group for charts
Select the Clustered Bar from the available options

To add a new category to the source data and to update the chart, Type in the new data to the end of the source data. Dry Fruits will be the new category, Cashew and walnut will be the items in the new category.