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.

12 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  

  • Hi,

    Once again after crash Nifty has started going up. Now we suggest all rises should be used as an opportunity to exit old long positions.
    This bull run will continue for few more days. Overall market is in bearish mood as in medium term its just a small rally due to short covering
    and result season.


    Happy Trading,

    ShareGyan

    By Blogger share, at 9/27/2008 12:06:00 AM  

  • I read your post . it was amazing.Your thought process is wonderful.The way you tell about things is awesome. They are inspiring and helpful.Thanks for sharing your information and views.
    share tips

    By Blogger share tips, at 6/01/2011 05:54:00 AM  

  • You made some decent points there. I looked on the internet for the issue and found most individuals will go along with with your website.

    Thanks & Regards,
    Stock Market Tips

    By Blogger Devang Visaria, at 9/04/2011 11:03: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 Devang Visaria, 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  

  • Hiiii,Nice article. I was checking constantly this blog and I’m quite impressed! Very useful information.Great Post and very good articles. You are doing very good job, keep posting articles. I will suggest all my friends to go this post. Thanks & Regards stock tips

    By Blogger richa88, at 2/21/2012 12:24:00 AM  

  • Its good to be here, very nice post, the content is amazing, keep posting friend it will be very helpful for everyone, Thanks for sharing. I really liked it.
    Thanks And Regards
    mcx tips

    By Blogger Commodity Tips, at 7/13/2012 11:04:00 PM  

  • 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