Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Bubble Map on Excel

Posted on 2012-04-05
6
Medium Priority
?
470 Views
Last Modified: 2012-05-27
Hi, does anyone have a good tool for creating bubble maps in excel? Similar to the ones you see online -- last one?

http://www.tushar-mehta.com/publish_train/data_visualization/10%20Dashboards.shtml
0
Comment
Question by:Angelmar
  • 2
  • 2
5 Comments
 
LVL 10

Expert Comment

by:Michael Vasilevsky
ID: 37812859
Not sure what you mean by "tool", and that link isn't working for me, but if you want to learn about bubble charts this might be a good place to start: http://chandoo.org/wp/2009/10/05/bubble-chart-tutorial/
0
 

Author Comment

by:Angelmar
ID: 37813191
i know how to make a bubble chart. what I am looking for is a template or software to have the bubbles appear on a map(us map) instead.
0
 
LVL 42

Accepted Solution

by:
dlmille earned 2000 total points
ID: 37815604
First you need to purchase Microsoft MapPoint http://www.microsoft.com/mappoint/en-us/MPLanding.aspx?refcd=go002208s_mappoint
or other 3rd party map software add-in.  Find one that allows you to plot bubbles or other charts on top of the map.  

Here's a free one that sits on Excel supporting bubble thematics:
http://freegeographytools.com/2010/excel-add-on-for-map-and-data-visualization

Here's a tip on how to overlay an actual bubble chart on top of a map, though it can take some work as you have to set up the x,y axis to align with lat and long's on the map:
http://www.mrexcel.com/forum/showthread.php?t=515764

Here's a blog on Excel dashboard which appears to have this functionality, though you might have to tweak VBA code to get it working for you:
http://www.clearlyandsimply.com/clearly_and_simply/2011/03/the-next-level-of-interactive-microsoft-excel-dashboards.html

There's also Tableau:
http://www.tableausoftware.com/solutions/data-visualization

SpotFire is one we use at work that can do this as well - and you can download a trial version to test it out.  I don't think SpotFire is an Excel add-in, but from the documentation it appears there's a good interface between the two.
http://spotfire.tibco.com/

Here's a Spotfire demo of crime statistics from their website, using bubbles in a geographical area.
http://ondemand.spotfire.com/Public/ViewAnalysis.aspx?file=Public/Crime%20Data%20(Arlington%20County)&waid=b456bc9331368fccb5867-b6d0

Personally, I do more sophisticated mapping, and I use MapInfo (an independent program, not part of Excel) and MapBasic (to do some automation) to do all my mapping and associated modeling.  It is one of the more powerful apps (and also has a free download) but may be more sophisticated that Spotfire (which I personally haven't used) though Spotfire I understand has good statistical and D/A functions which may be more up your alley.
http://www.pbinsight.com/products/location-intelligence/applications/mapping-analytical/mapinfo-professional/

If you have access to Excel 2002, you can probably do it with that as well, but after 2002, Microsoft makes this feature available via purchase.  I tried to find it in my version of 2002 and despite the Wiki's claims that Excel 2002 has it, I couldn't find it.  As I recall, it was fairly rudimentary, however.

There's a lot of dashboard software out there that uses mapping and supports thematics like bubbles, though you'll have to search more diligently to find those that sit atop of Excel.

Dave
0
 

Author Closing Comment

by:Angelmar
ID: 38011917
really didn't get me anything different than i already had.
0
 
LVL 42

Expert Comment

by:dlmille
ID: 38012649
>>really didn't get me anything different than i already had.

While my response may not have given you additional help, it was a broad and thorough effort, sharing tools that we use at my shop as well.  The C grading doesn't quite ring true based on my posting and your response.

Please explain the C grading.

Please see the following Grading Guidelines, as posted by our moderator, zorvek, here: http:/Q_27278078.html#a36563097:
Grading Guidelines

A: The Expert(s) either provided you with a thorough and informative answer or with a link to information that answered your question.

B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution but you needed more information to complete the task.

C: You have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information, and the answer, after clarification, lacks finality or does not address the issue presented.

Dave
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question