Stacked chart with 3 data sets (variables)

If I understand what you are saying (which might be difficult with so many different variables), it sounds like you want a clustered and stacked column chart. I would suggest that you start with this tutorial. http://peltiertech.com/clustered-sta...mn-bar-charts/
Pay careful attention to the way that he arranges the data in the spreadsheet for this chart. If you get the data arranged properly in the spreadsheet, then creating the chart is relatively easy.

This will probably not be the final solution to your problem, but it should give you a good start. I would suggest that you try the clustered and stacked column for one data set for each of the 5 stores. After you get it working for one data set, then we can work on extending it for several months.