Microsoft Office & VBA

Which VBA references you are using

VBA references Quite often you need to add some reference to be able to get some code to compile. This is because the code is referencing some external object that the Excel VBA does not […]

Colors

Visualizing tables

If you want to embed or publish Excel data to web pages, there are many solutions. Excel 2013 does fancy things with skydrive to share data, and there are plenty of activeX plugins and so […]

No Picture
Microsoft Office & VBA

Mapping and adding markers to maps

Plotting markers on a map. This article will cover 2 main topics How to use the most common APIs for adding markers and information layers to Maps How to plot Excel data directly on a […]

Colors

Code for color scheme explorer

More color schemes The purpose of this app is to select related colors that appear in a predefined scheme (for example pantone matching system etc). That means I’m always looking for more color schemes. If […]

Colors

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 of the year dealt with in  Selection of pantone ramps, and applies them to a […]

Apps Script & Java Script

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 […]

No Picture
Colors

Creating one color ramp from another

Lets say that we want to create a circular color ramp, as used in How to create a heatmap doughnut chart, as in the example shown on the right This is actually 2 steps, using […]

Colors

How to create a heatmap doughnut chart

A doughnut chart is sometimes used to show relative category shares, like this. Doughnut (and pie)  charts have a bad press. It is generally difficult to see relativity between categories, and there is usually a […]

Microsoft Office & VBA

gistThat Idea

Introduction Usually when I write about something here, I’ve either finished it, or at least done a proof of concept. This is just an idea at the moment and if you would like to contribute […]

Microsoft Office & VBA

How to update modules automatically in VBA

I first started to think about this problem when I found myself having to tailor workbooks for particular capabilities described on this site. I’m not great a fan of add-ins (for libraries), and I wanted to find a way of making the code openly available, and at the same create a general capability for people to share and update VBA code painlessly, either publicly, or between their own workbooks. […]

Colors

Charts and color ramps

What can you learn here? ramp color scales using in surface charts brighten/darken Creating Charts with colorRamps Create a heatmap in Excel showed how to make charts using the heatmap color ramp. Now that we have […]

Integrating Excel with Maps and Earth

Data Driven Mapping applications

Creating data driven applications straight out of Excel get it now This article will cover these main topics  How to create  rich applications which pulls together Google Maps ,Google Visualization, Twitter and Google Earth. How to […]

Classes

Promises in VBA

Using promises in JavaScript and other languages is the preferred way to orchestrate the completion of asynchronous activities. Here’s a (not perfect but fun) Promise implementation in VBA. Example includes getting data from Google Fusion tables. […]

Classes

cDataSet Model

What to download: All the examples contain all the classes needed for them to work and all projects can be found here. If you just want the main utility classes used throughout this site, in […]

Add-ons

Chord Snip

Chord snip is an add-on for Google Sheets that creates a Chord diagram as you type, gives you the SVG code to embed it in a web site and the ability to embed it in […]

Microsoft Office & VBA

Classes

What Is a Class? Classes are Objects which allow you to group a set of related functionality into one group. Once you have defined your class, you instantiate an instance of a class in order […]

Colors

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 to look at creating heatmaps as an Excel Chart, and also to automatically create a […]

Microsoft Office & VBA

Integrating Excel with Maps and Earth

Geocoding, Mapping and creating data driven applications straight out of Excel get it now This article will cover 3 main topics. I wrote all this stuff a few years ago, and some of the services may […]

Colors

Color ramp library

What can you learn here? ramp color scales gradient between colors Use a ramp library Generalized Color Ramps If you read A tagCloud in Outlook, How to create a tag cloud or Create a heatmap in Excel you would have […]

No Picture
Colors

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 snippets on color management in VBA so I thought I should centralize them for easy […]

Colors

Color Arranger

What is the Color Arranger An Apps Script add-on that allows you to arrange, merge and sort a Google Sheet using the background color properties.   You work on a sidebar preview of the colors […]