D3
Coronavirus-d3.js viz: Detecting and dealing with collisions in force simulations
These snippets look at dealing with collisions in a force-directed simulation […]
Visualization
D3
cv-viz: Virus infection simulation with D3.js
The coronavirus is with us, and naturally, there’s much interest in data on its mortality, reach and spread, and of course much discussion on lockdowns, health capacity, social distancing and how they might affect those […]
Apps Script & Java Script
Google Visualization API data
The source data colorTable we want to load to our parse.com database is currently in a Google Spreadsheet. With scriptDB, we can access it directly. However, to load data into parse we need to use the google visualization query […]
Apps Script & Java Script
Using Google Visualization charts and tables
javaScript: creating google visualization charts and tables This relates to Data Driven Mapping applications and the Javascript HowTo section Google Visualization tables and charts All visualizations are created from the dataViews mentioned in Using Google Visualization DataViews. Once […]
Snippets
How to control your vizMap application
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on vizMap applications can be found at Data Driven Mapping applications […]
Snippets
How to define your vizMap Application – visualizations
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on vizMap applications can be found at Data Driven Mapping applications […]
Snippets
How to define your vizMap application – Dictionary
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on vizMap applications can be found at Data Driven Mapping applications […]
Snippets
How to prepare for your VizMap application – Parameters
How to put markers on maps This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on vizMap can be found […]
Snippets
How to prepare for your vizMap application – Data
How to put markers on maps This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on vizMap can be found […]
Snippets
How to modify geocoding and mapping parameters
How to modify geocoding and mapping parameters This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on marker parameters can be […]
Apps Script & Java Script
How to add flightPaths on a Map
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on flightPaths can be found at Adding flight paths to Maps […]
Snippets
How to Overlay circles on a Map
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on marker quicklinks can be found at Overlaying circles and heatmaps What you […]
Snippets
How to use alternate Map icons
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on marker quicklinks can be found at Overlaying circles and heatmaps What you […]
Snippets
How to filter markers by Category
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on marker quicklinks can be found at Quicklinks and Categories What you […]
Snippets
How to add quickLinks to a Map
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on map quicklinks can be found at Quicklinks and Categories What you need […]
Snippets
How to put markers on maps
How to put markers on maps This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on map markers can be found […]
Snippets
How to Geocode addresses using Google Maps
This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on geocoding can be found in Complete Excel Address Data with […]
Apps Script & Java Script
Analyzing site content with GAS
One the things I wanted to play around with was visualizing this site content with d3. But first I needed to create something which would generate data from the site (any domain site actually). It’s easy […]
From VBA to Google Apps Script
How to make charts in Google Apps Script
The Charts Service Google Apps Script offers a charts service. Using this you can build a dataTable as input to a chart, as well as the chart itself. Elsewhere on this site I covered how to […]
Deprecated
Embedding Google Motion Charts in Excel
What are google visualization charts Google provides a growing number of cool charts that are not available in Excel. For this article we are going to focus on the the Google Motion Visualizations. Please take […]
Google API
Serializing Excel data for Google motion charts
In a previous section , I explained how to create javascript to create a Google Motion Chart directly from your from Excel data, and optionally embed it in your workbook. Since it is of course […]
Google Visualization
General Google visualization tool
We previously looked at how to embed a motion chart in excel, as well as how to serialize data as input to one. As a matter of fact, the interaction with the visualization API and […]
General JavaScript techniques
Apps Script as a proxy
If you try to access data in a different domain from a client-side app, you’ll often get an error about CORS (cross-origin resource sharing). I’ve dealt with this topic before in Cross Origin Resource sharing (CORS), […]
D3
Flight data from Fusion
I’ve been playing around with the live integration of large cloud based data sets with D3.js. Most visualizations with D3 use some kind of static data, but I became interested in pulling different source into d3. […]
D3
Excel tables to d3.js Force diagram
How to create d3.js force diagrams from excel tables In Sankey diagrams from Excel and Creating d3.js Tree diagrams the input data for these d3.js visualizations was of a specific layout. We are now going to look at a more generalized […]
D3
Eurovision results with crossfilter and dc.js
Since the 50’s, there has been an annual song contest involving many European countries. It’s a fairly bizarre event, but one of the most interesting things about it is the voting system. Countries vote for […]
D3
Big quiz score reports
‘m showing score reports for the BigQuiz app. This is an individual players score compared to the maximum he could have got as well as the number of questions that were correctly answered, and also comparing […]
Apps Script & Java Script
Color scheme explorer
In this section, we’ll build an application that pulls together many concepts already covered elsewhere on this site. You can run it standalone at xliberation.com, or below, embedded in this page The target application Pulling together Playing […]
Apps Script & Java Script
d3.js and parse mashup
This is an interesting d3.js and parse.com mashup of a number of topics covered on this site. The target is to build an app that Retrieves color scheme data from a parse.com database, much like […]
Visualization
University Rankings visualized
Using the Guardian UK university 2014 rankings to demonstrate, here’s how to mashup a few bits and pieces to visualize them. This is pretty generalized, so can be applied to any data set with fairly minimal changes. […]
Google Visualization
Google Visualization
Create Google visualizations straight out of Excel. Here you can download a prebuilt application, googleCharts.xlsm that demonstrates how to integrate google Visualizations with Excel. The subsequent pages are about how to develop such an application […]
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
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 […]
Apps Script & Java Script
How to use javaScript from VBA
What can you learn here? scriptcontrol object call from VBA use javaScript The ScriptControl Object This object gives you access to a scripting engine that will accept scripting in both javaScript and VBScript. Since this site has […]