title: stacked column chart for two data sets - Excel
body: <p>I am new here, although I have been browsing the blog several times before.</p>
  
  <p>I wonder if there is some way (also using VBA, if needed) to create a stacked column chart displaying two different data sets in MS Excel 2016. </p>
  
  <p>Looking around, I saw the same question received a positive answer when working with Google Charts (here's the thread <a href="https://stackoverflow.com/questions/17925722/stacked-column-chart-for-two-data-sets-google-charts">stacked column chart for two data sets - Google Charts</a>)</p>
  
  <p>Basically, I have two tables about 2 countries with monthly data per different years. Sample:</p>
  
  <p><a href="https://i.stack.imgur.com/8dLX0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8dLX0.png" alt="Excel sheet sample"></a></p>
  
  <p>The output I want is to show years on the horizontal axis and having a country represented in a stacked column that piles up monthly data <strong>on the side</strong> of the column of the other country (like the chart made using Google Charts as explained in the <a href="https://stackoverflow.com/questions/17925722/stacked-column-chart-for-two-data-sets-google-charts">the thread linked above</a>.</p>
  
  <p>The solution should look that sample:</p>
  
  <p><a href="https://i.stack.imgur.com/SPctV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SPctV.png" alt="wanted solution"></a></p>
  
  <p>I did not find an answer to that question, can you please provide some help on that?</p>
  
  <p>Please also note that I have very basic skills in VBA, i.e. I can more or less understand a code when I read it, but I am not able to write one myself.</p>
  
  <p>Thanks a lot to everybody</p>