This blog post from Ann K Emery provides step-by-step guidance for creating a small multiples bar chart using Excel.
The 10 step process provides detailed guidance and screen shots of each stage of the method.
Emery, A. K., (2013), How to make a small multiples bar chart in excel. Retrieved from: http://annkemery.com/small-multiples-solution/
'How to make a small multiples bar chart in excel' is referenced in: