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 out a linear ramp. How about a circular one?

Luckily How to create a heatmap doughnut chart could be used to layout both the scheme and its ramp.

Using Doughnut chart to show color ramps

Using the previous techniques and libraries described in Ramping color swatchesLooking up color tableAlternative schemes, and Playing around with colors in VBA it becomes more or less a one liner to create the chart below - which shows the label sections, their underlying colors and a circular ramp between them.


Here's the code for creating the diagram above, using the libraries in the cDataSet.xlsm workbook.

create pantone fashion circular ramp




Multiple column ramps

So how about showing multiple columns.


This time we are going to use the last 3 years Pantone fashion colors, as defined here


and we get this.. we can see the tone changing over the past 3 years. 

Changing granularity

So that doesn't really look to great, so we can change the plotting granularity parameter from the default of 300 to 1 and we get this.
Here's the code for creating the diagram above, using the libraries in the cDataSet.xlsm workbook.

create pantone fashion circular ramp



For help and more information join our forum,follow the blog or follow me on twitter.



Comments