Sub - Divided or Component Bar Diagram :

Sub -Divided or component bar diagrams are to be used if the total magnitude of the given variable is to be divided into various parts or sub-classes or components. The use of sub-divided bar diagram is not suggested if the number of components exceeds 10. For such, pie or circle diagram is appropriate.


Step: First, select data. See below figure as an example :

From Insert tab, click on Column "Stacked Column' icon.

 Stacked column is useful if the data is in value , not in percentage. By stacked column, we get the below figure.

But, we need comparision of Family A and Family B, which should be on Vertical axis. For that, from chart tools, click on switch rows/column as shown below:

Now, we can see different components default represent by different colors, which you can format as per your choice. Now, add labels to show which color represent which component. Click mouse third button and select "Add Data Labels", which is shown below in diagram :

By adding the data labels, we get the value . To show the component data, again click mouse third button, and click on Format Data Labels :

And in Format Data Labels box, click on Label option , and from label contains select "Series Name ".

Here, we have sub-divided diagram shown below :

Thank you!