bar graph on a map… using Excel! WIP
Problem Statement: To plot a monthly graph by state preferably on a map for better visualizations.
I’ve tried to use individual graph and position it on an underlying map, but it proved to be a tedious and repetative task. On one of my web wandering session through excel related web pages, I stumbled upon this page from Chandoo’s PHD blog detailing on how to plot medals won by individual country. Primarily it use x,y scatter chart to plot a coordinate on a map. X & Y values being fix as a coordinate and the bubble size varies according to medal tally.
I got an idea to use x,y scatter chart being as a main coordinate plotter, but how can we replace the bubbles with a bar chart. Maybe using VBA or macros, it is possible to do that, but i don’t know. After much tweaking around and a snap of idea, here is the first result. A crude result as a WIP.
Form the picture, i think you can guess the technique that i used ;)
Pending Problem : The bar graph is mono color. I want to differentiate several level of performance in the chart (good, level & below par), in each individual graph.
Tags: chart, English, visualisation
December 1st, 2008 at 3:29 pm
uk uh…dahsat2x
December 1st, 2008 at 11:35 pm
This is good stuff… Here is another fun and probably easier way around this. Since we already have avg. lat and long for each country, I would just use VBA to get me bar charts and then place them on map at the set x,y locations. that way you can get as many colors as you want.
December 2nd, 2008 at 8:27 am
[...] Vote bar graph on a map… using Excel! WIP [...]
December 9th, 2008 at 12:17 am
[...] My Blog xSaed, nating els « bar graph on a map… using Excel! WIP [...]