Make a mekko chart in Excel 2007 in three easy Steps


R

ravi6108

Data for making Mekko Chart

Share of market segment
Segment Sement% Alpha Beta Gamma Delta
A 40% 60% 25% 10% 5%
B 30% 40% 30% 20% 10%
C 20% 30% 30% 20% 20%
D 10% 25% 25% 25% 25%

Ans:

Step1:
Make duplicate rows three each for the segment A,B,C, and D
Segment% Alpha Beta Gamma Delta
A 60% 25% 10% 5%
A 60% 25% 10% 5%
A 60% 25% 10% 5%
B 40% 30% 20% 10%
B 40% 30% 20% 10%
B 40% 30% 20% 10%
C 30% 30% 20% 20%
C 30% 30% 20% 20%
C 30% 30% 20% 20%
D 25% 25% 25% 25%
D 25% 25% 25% 25%
D 25% 25% 25% 25%



Step2:
Fill other numbers in 'Segment%' column to fill the XAxis Data

Segment% Alpha Beta Gamma Delta
A 0(AStart) 60% 25% 10% 5%
A 0 60% 25% 10% 5%
A 40(Aend) 60% 25% 10% 5%
B 40(BStart) 40% 30% 20% 10%
B 40 40% 30% 20% 10%
B 70(Bend) 40% 30% 20% 10%
C 70(CStart) 30% 30% 20% 20%
C 70 30% 30% 20% 20%
C 90(Cend) 30% 30% 20% 20%
D 90(DStart) 25% 25% 25% 25%
D 90 25% 25% 25% 25%
D 100(Dend) 25% 25% 25% 25%

Step3:
Finally, Make the staked Area Chart
Right Click on the X Axis, Select Format Axis,In Axis Type Select Date Axis

Source:http://peltiertech.com/WordPress/marimekko-charts/
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mekko charts in Excel 2007 8
stepping chart 2
Make chart formatting as easy as it was in 2003! 1
step chart 1
Chart with three variables 8
Step/Staircase Charts 6
Step Line Charts 2
Step change charts 1

Top