Visualize Data with Color Coding

color coding dataWant to quickly see (without reading text) if a particular row of data is *bad*? You can always color code the data. You can visualize your data with conditional formating.

Start by downloading After you unzip, you will see one file, ColorBackground.svb.

To see the value of color coding, start STATISTICA and open the downloaded macro. Now open the example dataset, “Cat Clinic.sta”.

If you don’t know how to open example datasets, start by selecting the File menu -> Open Examples menu. Now open the Datasets folder. You will see hundreds of STATISTICA spreadsheets. Select  “Cat Clinic”.

We are going to see which cats are overweight with a standard BMI (body mass index) formula.

BMI = (weight / (height x height)) x 703

NOTE: We know there is a different BMI formula for cats. But our dataset does not include the rib cage measurement, so we are using the human BMI formula

You have the dataset and macro open. The macro has the focus. Type F5 to execute the macro.

Variable 3 (V3) has the weight. Variable 4 (V4) has the cat’s height. So the calculation for an overweight cat is:

(V3/(V4*V4)) * 703 > 24

color coding over weight cats

Click OK. The data is now color coded. Overweight cats are red.

color coding data for visualization


Image Credit: Color Coded Bookshelf


About statsoftsa

StatSoft, Inc. was founded in 1984 and is now one of the largest global providers of analytic software worldwide. StatSoft is also the largest manufacturer of enterprise-wide quality control and improvement software systems in the world, and the only company capable of supporting its QC products worldwide, with wholly owned subsidiaries in all major markets (StatSoft has 23 full-service offices, on all continents), and its software is available in more than 10 languages.

Posted on March 13, 2013, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: