Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Make a mekko chart in Excel 2007 in three easy Steps

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/
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Make a mekko chart in Excel 2007 in three easy Steps

Good idea
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mekko charts in Excel 2007 [email protected] Charts and Charting in Excel 0 August 15th 12 01:43 PM
Mekko charts in Excel 2007 oliver hesketh Charts and Charting in Excel 1 March 3rd 12 09:52 PM
steps of Setup and Deployment for C# Excel 2007 project in Visualstudio 2008 shantanu Excel Programming 0 February 13th 09 02:52 AM
Make chart formatting as easy as it was in 2003! Bryan Metz Charts and Charting in Excel 1 December 13th 08 09:39 PM
Mekko charts in Excel 2007 George Burdell Charts and Charting in Excel 3 April 19th 07 01:35 PM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"