Make a mekko chart in Excel 2007 in three easy Steps

  • Thread starter Thread starter ravi6108
  • Start date Start date
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/
 
Back
Top