How to Make a Chart with Subcategories

There is one important thing in charts. Good labeling. That's why it is useful to be able to insert professional labels that share the chart into subcategories.

Chart with Subcategories

Enter data into an Excel sheet in the following manner. The key point here is to use proper, correct labels. In column A, you write subcategories, and in column B, you write the names of particular columns of data.

data table chart subcategories

Now highlight the data and go to the ribbon. Select insert tab and click clustered column chart.

chart with subcategories template

As you see, there are subcategories on the chart. Now your chart is clear and useful.