Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: Graph: Colouring table cells based on conditions or data distribution


From   <Stefan.Gawrich@hlpug.hessen.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: Graph: Colouring table cells based on conditions or data distribution
Date   Fri, 16 Oct 2009 09:33:53 +0200

Hi Statalisters, 

many of you may know this feature from MS Excel (from Version 2007 on).
It's more or less a "choropleth map" for data tables (cell colour
depends on cell value relative to the table distribution or on
conditions).
(see:
http://msdn.microsoft.com/en-us/library/bb428945%28office.11%29.aspx)


In my work I often have to display both a table (to pick data from) and
a graph (for visual impression) to users and I'm constantly trying to
combine both. Colouring tables is one way to do this if rules/conditions
are user-defineable. 

I thought about setting up a coloured twoway table in Stata but that
doesn't seem to be easy: 

Stata's results window doesn't allow for fancy tricks so the table must
be in a graph.

Spmap by Maurizio Pisati has all colouring options I need and can be set
up with rectangular polygons and polygon centroids for labeling. 
But it's not written for that purpose, so it's difficult to set up:
- a n*m polygon-coordinates dataset for each table must be created
- linkage of table cells to polygons
- handling of missing values and category "missing"
- use of value labels
- display of row and/or column totals (yes/no) 
- ...

I already started to produce some coloured tables with spmap but these
are only first tests. 
I'm curious if there is any other graph framework available in Stata
which also may be suitable for this purpose.

Best wishes
Stefan Gawrich






*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index