Make a mekko chart in Excel 2007 in three easy Steps

Discussion in 'Excel Charting' started by ravi6108@gmail.com, Jan 12, 2013.

  1. Guest

    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/
     
    , Jan 12, 2013
    #1
    1. Advertisements

  2. Carey Duryea Guest

    Good idea
     
    Carey Duryea, Mar 2, 2013
    #2
    1. 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 (here). After that, you can post your question and our members will help you out.