- Introduction & key concepts
-
Download: PowerPoint and Excel file
-
Intro and rationale for using Mekko charts 2 min
- Building the chart
-
Prep Excel and insert 3 min
-
Apply theme and move to other series 3 min
-
Finetuning and wrap-up 2 min
- Completion
-
Complete course 1 min
Analyze market size by geography
Course 3 of 7 in Financial Planning
Learn how to analyze market size by geography
By the end of this course, you will be able to analyze market size by geography using a Mekko chart.
- Choosing the right approach: Understand why a Mekko chart is the best choice for displaying geographic market size and how it captures both magnitude and share in one view.
- Preparing and inserting the chart: Learn how to structure your excel data, insert the Mekko chart, and apply the appropriate theme for consistency.
- Customizing for clarity: Refine your chart by adjusting series labels, fine-tuning formatting, and ensuring the chart communicates insights effectively.
These techniques will help you turn raw geographic data into a clear and impactful chart that supports confident decision making.