Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Mekko (Marimekko) / Matrix graphs ?
Go
New
Search
Notify
Tools
Reply
  
Mekko (Marimekko) / Matrix graphs ?
 Login/Join
 
Silver Member
posted
Has anyone had any luck with creating mekko charts ?

A mekko chart allows you to "communicate up to three levels of data (such as Sales by Competitor by Market Segment) in a single, two-dimensional graph."

some examples...

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

http://www.optimist123.com/optimist/2006/08/energy_facts_ce.html

http://peltiertech.com/Excel/Charts/NonNative.html#MatrixChart

This message has been edited. Last edited by: Stephen,


WebFocus 7.11/7.6
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Hi Stephen,

Are you familiar with Treemaps and is this a similar concept? I have not heard of the Mekko chart.

A Treemap is a two dimensional representation of hierarchical data where each data is represented by a cell. The arrangement, size and color of each cell represents the attributes of the data element.

I believe the 7.6 version of Webfocus has heatmap, but not Treemap functionality.
 
Posts: 2 | Location: World Trade Center - Boston | Registered: February 08, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks for the response. I will investigate the heat map.

In Excel you can use a variable width bar graph to give you a Matrix (mekko) chart, but it requires a number of setting that i can't dupliate with Focus.

Excel process described here...
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508


WebFocus 7.11/7.6
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Mekko - try this

RPT #1
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK

RPT #2
ON TABLE PCHOLD FORMAT EXL2K CLOSE

this will allow you to out two excel reports on 1 page

This message has been edited. Last edited by: tlbrydie2,




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Mekko (Marimekko) / Matrix graphs ?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.