SOS How To Make Stacked Bar Chart In Excel?

I need to make a stacked bar chart on a recurring basis. Included a few pictures here. The bar chart needs to show 15 grocery stores. Each grocery store has multiple applications. I need to show the number of users for each application by grocery store. Each grocery store application varies in maximum user size (between 100 -50,000).

I have a few problems: My data doesn’t have the exact data I need. The data has emails (with grocery stores embedded). The data also doesn’t have direct numbers, just “FALSE”. How do I turn all of this into a graph automatically and easily change the colors? Any advice is SO appreciated, thank you! I will literally PayPal for help.