title: How can I create a Marimekko chart in Google Sheets?
body: <p>I couldn't find any thread in the community about generating a Mekko charts just using GSheets.</p>
  <p>Does anyone how we can do that?</p>
  <p>Here's how to do it in Excel: <a href="https://www.mekkographics.com/how-to-create-a-marimekko-chart-in-excel/" rel="nofollow noreferrer">https://www.mekkographics.com/how-to-create-a-marimekko-chart-in-excel/</a></p>
  <p>I have figured out how to almost get there with some data processing. For example, let's review the GDP by country and source, to visualize its distribution. I was able to get the Mekko chart, but I'm missing the countries in the X axis.</p>
  <p>Here's the data and spreadsheet: <a href="https://docs.google.com/spreadsheets/d/1xVFf8_pbVj45W39qDs7MY5cLE_zf1YlJcSzvqWfazg8/edit#gid=1149840583&amp;range=V1" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1xVFf8_pbVj45W39qDs7MY5cLE_zf1YlJcSzvqWfazg8/edit#gid=1149840583&amp;range=V1</a></p>
  <p><a href="https://i.stack.imgur.com/JaCQG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JaCQG.png" alt="enter image description here" /></a></p>