There are lots of references to color on this site, and it seems to be a subject second only to jSon in popularity. In this section I’ll bring together some new and some older color related topics.
Note about color
Although color plays an important role in charting, and although I use Excel charts here it’s simply for their assistance in displaying colorful objects – I’m not advocating that the charts that follow are useful. It’s been said that colors are the least effective way of describing quantitative data, and I think that’s probably right. I’m just playing around with color.
Alternative schemes showed Ramping color swatches using the Pantone spring 2013 collection colors as the ramp milestones. So far we’ve been laying …Read More
In Ramping color swatches I showed how you count transition smoothly between colors by manipulation of the red, green and blue …Read More
These articles are abridged from my book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available for …Read More
Creating heatmaps An easy way to create heatmaps is to use conditional formatting in your spreadsheet. However, we are …Read More
Following on from Coloring maps and other shapes, here’s a bit of fun that takes the tables of Pantone colors …Read More
Let’s say you have a color, and you want to find the closest match in defined color scheme set. The …Read More
In Playing around with colors in VBA I introduced the concept of a color table. This is just a list of a …Read More
There are a few items on this site that cover color ramps and other color manipulation topics. I’ve built up a …Read More
In Looking up color table I showed how to look up colors from a growing table of color models, in order to …Read More
When I was writing the Color Fiesta section, I noticed a tweet about something called the Pantone Spring 2013 color collection. I …Read More
If you want to embed or publish Excel data to web pages, there are many solutions. Excel 2013 does fancy …Read More
Check on the menu bar for color topics covered in other modules