Excel - Marimekko Charts

To create a Marimekko chart select the data for the chart – this can be in percentages or in decimals but should add up to 100% or 1 respectively across the rows and columns. 

Select New Chart in the ribbon or side bar.

• In the Chart dialog, select Marimekko and in the sub chart type list on the right select either:
  • Marimekko
  • Marimekko-Bar Mekko
• Select the required custom chart theme from the dropdown (the chart will be formatted accordingly).
• Click OK.

The Custom Chart Wizard will open with the fields populated based on your selection.

• Edit any of the fields by clicking on the button at the end to collapse the dialog and selecting the correct data or for titles, typing the text in manually.
• Click OK.

Create needs to add data alongside the original chart data in order to create the Marimekko chart. If there is already data in the worksheet in those cells this message will appear.

Select New Sheet to insert the Marimekko chart and the associated data on to a new worksheet OR select Insert to insert it on the current worksheet (Create will insert rows and columns for the new data).

The formatted chart will appear on the worksheet.

Save the workbook. Send to PowerPoint or Word using Quick Send.