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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. phoney
    Replies:
    1
    Views:
    139
    tjtjjtjt
    Nov 13, 2004
  2. Barb Reinhardt

    3D Chart with Continuous Data in all three Axes

    Barb Reinhardt, Jan 7, 2005, in forum: Excel Charting
    Replies:
    3
    Views:
    86
    Barb Reinhardt
    Jan 10, 2005
  3. Chris

    Three line charts on same chart

    Chris, Feb 28, 2005, in forum: Excel Charting
    Replies:
    2
    Views:
    94
    Jon Peltier
    Mar 1, 2005
  4. KB
    Replies:
    1
    Views:
    66
    Barb R.
    Mar 16, 2005
  5. Julie
    Replies:
    1
    Views:
    88
    John Mansfield
    May 13, 2005
  6. JAS123
    Replies:
    1
    Views:
    117
    Barb R.
    Jun 9, 2005
  7. George Burdell

    Mekko charts in Excel 2007

    George Burdell, Apr 19, 2007, in forum: Excel Charting
    Replies:
    8
    Views:
    229
  8. Bryan Metz

    Make chart formatting as easy as it was in 2003!

    Bryan Metz, Dec 13, 2008, in forum: Excel Charting
    Replies:
    1
    Views:
    96
    Jon Peltier
    Dec 13, 2008
Loading...