Group Items in Excel Chart
The following is an article on grouping like items in a chart. In essence having a parent label in the X axis and its associated child. The way I will do this is simple enough, it is all about how you set up your data. The following is an example of the data table and how it needs to be set up.
After the table is set up as the table is set up above simply highlight the table and select the Insert Menu.
Choose a column Chart and the 2D Column. It is the first chart in the list of column charts. This should produce the following chart.
Each of the items are separated into the categories for the state