Jul16

Market partition - Mekko chart in Excel, no add-ins

Tagged with: .

Mekko charts are two dimensional graphs that analyze how data is partitioned against two variables, the X and Y axes. The width of the columns is proportional to data represented by the columns. Individual segment height is a percentage of the respective bar total value.

Related posts:

  1. Column - Stack combination chart in Excel Not very common, but sometimes useful, this chart is made...
  2. Yet another in-cell Excel bar chart technique Two improvements over the technique described by Juice Analytics and...
  3. Modeling market adoption in Excel with a simplified s-curve UPDATE 10/31/2007: Here is a screencast for this model Often...
  4. Math on the simplified market adoption s-curve for Excel I’ve got a number of questions on the simplified Excel...
  5. Presenting time series of market participation One very common need in almost any industry is to...

Feed for this Entry Trackback Address

3 Comments to “Market partition - Mekko chart in Excel, no add-ins”  

    1
  1. At 10:14 am on July 31, 2007
    Bob Kitzberger Says:

    Juan - did you post an Excel example? I didn’t find any on the blog. I’ve done some Mekko’s in Excel and am interested in the technique you use. Thanks.

    2. 2
  2. At 12:48 pm on May 4, 2008
    CFO Says:

    CFO ?????? - ?????????? ???????? ? ?????? ???? ???????? ???????????? ? ???, ???????????????? ????????????, ? ?????? ???? ???????? ???????????? ? ???, ??? ??? ??????? ?????????? ??????????, ??? ???????????? ?????????????. ???? http://www.cfo-russia.r

    3. 3
  3. At 2:34 pm on June 5, 2008
    rn Says:

    thanks

Leave a Reply