Home MS Excel TutorialCharts Chart with subcategories

Chart with subcategories

by Easy Excel Tutorials

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.


You can download the Template here – Download

You may also like