Statalist


[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   Sergiy Radyakin <serjradyakin@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: Graph: Colouring table cells based on conditions or data distribution
Date   Fri, 16 Oct 2009 12:05:05 -0400

Dear Stephan,

have a look at this page:

http://www.adeptanalytics.org/radyakin/stata/graphics/radyakin_graphics.htm

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

Best regards, Sergiy Radyakin



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

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