How to create stacked bar chart with country data

As the one helping out on jgodfrey's thread, I will note that you appear to have the same problem as him -- your table does not contain the necessary data to create a stacked column chart. You will need some way (details will depend on exactly how your data are laid out) to:
1) Count the number of countries -- Is each country listed in its own cell, so you can simply use the counta() function, or are your lists of countries text strings in a single cell, so you need a text function to identify country names (and distinguish from conjunctions like "and" which shows up in one case) and then count the countries. Or maybe use Text to Columns to separate country names into their own cells.
2) From the count of countries, create a row of 1s which can be used in the stacked column chart.
3) Create the stacked column chart (https://support.office.com/en-us/art...0-e9ab353c4c00 ).
4) Insert the desired data labels. Pre-2013, this is most easily accomplished using Rob Bovey's XY chart labeler add-in (appspro.com ). 2013 and later have this feature built in. If the country names are a single string, you may need to execute a text to columns to separate out the countries to their own cells, if you did not do it as part of getting the counts.

What part do you get stuck on?