Hours wasted compiling this spreadsheet and associated Google Gadget, Motion Chart. The data still needs refining and but for many values it works well giving the user the opportunity to view three different parameters (axis of a graph and relative size of the plot) for related items. In my case, measures of different English universities related to the nature of their student populations. To help get the hang of it, set colour to ‘unique colours’; size to ‘total all students’ then play around by choosing data on both axis and select a particular institution you are interested in tracking. Finally, start the timeline…
Motion Chart – English HEI
Leave a reply