How to Make a Mekko (Marimekko) Chart in Excel

🎓 Create 10 Professional Dashboards (ONLY $9.99!) ▶️https://bit.ly/35lO8OK
⬇️ Download the workbook: https://bit.ly/4hhzmgW
In today’s video, we’re diving deep into one of the most effective tools for visualizing complex data in Excel—the Mekko Chart. This powerful chart is also known as a Marimekko Chart, and it helps you visualize the relationship between two categorical variables. Whether you're analyzing market share or comparing multiple segments across different categories, the Mekko Chart will give you a visual representation that's easy to interpret and incredibly insightful.
A Mekko Chart, sometimes called a Marimekko Chart, is a type of stacked bar chart, but with variable-width bars. The width of each bar corresponds to the size or proportion of a specific segment, and the height of each segment reflects the value of that category. This makes it a powerful tool for analyzing both the size of categories and their relative contributions.
The chart allows you to compare the percentage share of different segments within a specific category, making it particularly useful in market analysis, business segmentation, and even financial forecasting. The Mekko Chart is a visual powerhouse that combines the best aspects of both bar and pie charts, making it easier to spot trends and patterns in your data.

⌚ TIMESTAMPS
00:00 Introduction
01:09 Preparing Your Data
01:54 Creating the Helper Table
06:52 Find the Midpoint values of each market
08:03 Add Label Marker and Label
10:11 Insert the Chart
12:35 Format Horizontal and Vertical Axes

🎓 Join 60,000+ professionals in our courses for ONLY $9.99 !!
👉 https://www.udemy.com/user/andrewex/

🎓 BEST-SELLING COURSES
📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK
📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB
📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq
📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm
📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw
📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr
📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8
📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy
📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/4mjDjVT
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME

🔽 CONNECT WITH ME
• Official website: http://www.mellontraining.com
• LinkedIn:   / andreasexadaktylos  
• Twitter: https://x.com/mellontraining
• Facebook:   / mellontraining  

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍

#excel #mekkochart