How to create a Mosaic Plot (aka Mekko) in Excel? | Marimekko Chart | Stacked Spinogram

Select Mosaic Plot. Select your data. Click “Create Chart From Selection” button. You can create Mosaic Plot in a few minutes with a few clicks.

A Marimekko chart, also known as a Mekko chart or Mosaic plot, is a data visualization tool that combines aspects of a bar chart and a 100% stacked bar chart to represent categorical data across multiple dimensions.

The chart is used to display the relative proportion and distribution of different categories within each dimension.

Key Features of a Marimekko (aka Mosaic) Chart:
1. Width and Height Representation:
• Width: The width of each bar corresponds to the total value of a particular category.
• Height: The height of segments within each bar represents the proportion of subcategories within that category.
2. Visualizing Two Dimensions:
• One dimension is represented by the width of the bars.
• The other dimension is represented by the stacked segments within each bar.
3. Proportional Analysis:
• The chart allows for a proportional comparison across categories and subcategories, making it easier to understand the composition and distribution of data.

Install ChartExpo charts add-in for Microsoft Excel or Office 365

How to install ChartExpo add-in in Excel & Office 365 video

Install ChartExpo charts add-on for Google Sheets

Explore more charts and visualizations

Video Summary:
This video explains "How to create a Mosaic Plot in Excel?". You can use the option of properties to enhance your charts.

Chapters:
0:00 Data requirements for a Mosaic Plot.
0:36 How to construct data for a Mosaic Plot?
0:56 How to create a Mosaic Plot in Excel from sheet data?
2:32 How to customize a Mosaic Plot using properties?
4:33 How to export a Mosaic Plot in JPG, PNG, SVG and PDF?

#chartexpo #datavisualization #datastorytelling #dataviz #visualization #charts #graphs #spreadsheet #excel #mosaicplot

Tags:
Custom charts
Advance charts
Professional charts
Data charting
Data visualization tools

Excel graphs
Advance Excel charts
Excel data visualization
Excel Add in
Excel chart tutorial
Excel chart tricks
Impressive Excel charts
Build Modern Excel Charts

mosaic plot
matrix chart
stacked spinogram
spineplot
olympic or submarine chart
Mondrian diagram
mekko chart
100% stacked bar chart