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

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!

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.  


Sergiy Radyakin

have a look at this page:

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,  <>
> many of you may know this feature from MS Excel (from Version 2007
> 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:
> In my work I often have to display both a table (to pick data from)
> a graph (for visual impression) to users and I'm constantly trying to
> combine both. Colouring tables is one way to do this if
> 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
> be in a graph.
> Spmap by Maurizio Pisati has all colouring options I need and can be
> 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:

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