Excel here

Friday, September 08, 2006

Teaser for the weekend: How to get Graphs on Maps in Excel

[Click on the image for a bigger version]

Often business data goes hand in hand with geographical data. Thanks to tools like Google Maps and several associated mash-ups. But often it might be required to show data on a map to create an effect or draw some conclusions.

An example: Lets say you are analyzing annual sales in various States of US. Now usual ways of doing it include tables, bar/pie charts etc. But much more intuitive way would be to use an US outline map with bubbles in each state with their sizes representing segment/product-wise sales.

I had to do a similar analysis sometime back. And I did it in our dear excel itself without much pain (well, it is not so straightforward, but pretty much do-able)

So, here is a teaser for all the R1C1 readers. Try to findout the way for getting the following above graph in excel. No macros used (although, some amount of manual labour was!) The 3 colored bubbles represent 3 different segment/product figures (be it sales, profits, employees or anything you like).

Leave a comment with outline solution if you have one, Or wait till next week to find a simple enough way to do this.


Type: Teasers, Graphs, Data Analytics, Data Representation, Visualization
Applicability: for situations with both {sales, profits, people} and geographical data
Excel Knowledge Required: Moderate to Advanced
Ease of Implementation: Medium


PS: from this post onwards, I will be including the above format table with every post. To make the usage of R1C1 better.

7 Comments:

  • I read with your interest your Teaser about plotting sales date from MS Excel onto a map. When will you post your solution.

    Regards,

    Jason P

    By Blogger Jason P, at 1/26/2007 05:40:00 PM  

  • Very efficiently written post. It will be valuable to everyone who uses it, as well as myself. Keep doing what you are doing ? looking forward to more posts.


    Thanks & Regards,
    Stock Market Tips

    By Blogger Stock Market Tips India, at 9/13/2011 10:44:00 PM  

  • I have been reading your entries all through my morning break, and I must admit the whole article has been very enlightening and rather well written. I assumed I would assist you to recognize that for some reason this weblog does not view well in Internet Explorer 8. I wish Microsoft might stop converting their software. I’ve a query for you. Could you thoughts replacing weblog roll hyperlinks? That would be in point of fact neat!
    technical analysis training | learn technical analysis

    By Blogger Ian, at 9/16/2011 11:38:00 PM  

  • I would certainly claim, impressed along with your site. I had created no trouble navigating through all of the tabs and details may be astonishingly very gain access to. I stumbled upon what I wanted instantly ?n any respect. Quite great family. Could be thankful whenever you add forums the like, very easily a ideal means for your consumers to talk. Outstanding role..
    SEO Training School

    By Blogger Ian, at 11/17/2011 02:23:00 AM  

  • Timeless info. I can’t tell you how often we discuss topics like this in group.hank you for starting this blog. I look forwarding to following.You completed some good points there. I did a search on the subject and found nearly all persons will agree with your blog.
    Stock Market Training
    Technical analysis course

    By Blogger nasir.khan, at 7/22/2012 03:15:00 AM  

  • Visiting this blog is our real pleasure. Should like to thank admin for sharing such a useful information and starting this thread in addition to that we suggest traders not to panic when market is in profit booking state.
    Good returns with Stock Tips |Commodity Tips
    Check out ones.

    By Blogger Raahi, at 8/03/2012 03:00:00 AM  

  • Interesting article. Were did you got all the information from? Anyway thank you for this great post!


    Commodity Tips
    MCX Tips

    By Blogger AshaSoni, at 12/13/2012 04:18:00 AM  

Post a Comment

<< Home