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

 From "Nick Cox" To Subject RE: st: AW: Graph: Colouring table cells based on conditions or data distribution Date Fri, 16 Oct 2009 17:12:11 +0100

```Another red-green gradation!

http://en.wikipedia.org/wiki/Color_blindness#Red-green_color_blindness

In two books that have crossed my desk recently, (subdued) orange and
blue are used for basic contrasts of two categories to good effect.

Few, Stephen. 2009. Now you see it: Simple visualization techniques for
quantitative analysis. Oakland, CA: Analytics Pres.

Hastie, Trevor, Tibshirani, Robert, Friedman, Jerome. 2009.
The elements of statistical learning: Data mining, inference, and
prediction. New York: Springer.

Nick
n.j.cox@durham.ac.uk

htm

If this is something that you are looking for, contact me to get the
program files.

On Fri, Oct 16, 2009 at 3:33 AM,  <Stefan.Gawrich@hlpug.hessen.de>
wrote:
>
> 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.
>

*
*   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/
```