Color Fiesta

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.

Color topics

Alternative ramp layout

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

Alternative schemes

In  Ramping color swatches I showed how you count transition smoothly between colors by manipulation of the red, green and blue …
Read More

Color Arranger

What is the Color Arranger An Apps Script add-on that allows you to arrange, merge and sort a Google Sheet …
Read More

Color scheme explorer

In this section, we’ll build an application that pulls together many concepts already covered elsewhere on this site. You can …
Read More

Color Schemes and palettes

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

Create a heatmap in Excel

Creating heatmaps An easy way to create heatmaps is to use conditional formatting in your spreadsheet. However, we are going …
Read More

Excel dress up doll

Following on from Coloring maps and other shapes, here’s a bit of fun that takes the tables of Pantone colors …
Read More

Find nearest color match

Let’s say you have a color, and you want to find the closest match in defined color scheme set. The …
Read More

Looking up color table

In Playing around with colors in VBA I introduced the concept of a color table. This is just a list of a …
Read More

Playing around with colors in VBA

There are a few items on this site that cover color ramps and other color manipulation topics. I’ve built up a few …
Read More

Ramping color swatches

In Looking up color table I showed how to look up colors from a growing table of color models, in order to …
Read More

Selection of pantone ramps

When I was writing the Color Fiesta section, I noticed a tweet about something called the Pantone Spring 2013 color collection. I …
Read More

Visualizing tables

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