Originally Posted by hanvyj

You can set the Horizontal (Category) axis labels to a range containing two columns, the first column will be the group and the second the categories.

I've attached an example.

It also works with multiple groups levels!