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 which share chart into subcategories.

1. Enter data into Excel sheet in the following manner. Important here is to proper correct labels. In column A write subcategories and in B column there are names of particular columns of data.

data table chart subcategories

2. Now highlight the data and go to 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.