I have just finished an add-on to what S M C has already done, adding graphs for continents, countries, and regions. I have not changed any of S M C's code, except to rename some of the sheets. I did delete a couple of the world graphs that were previously included in the file, but they can be added back from S M C's file.
Here are the graphs that are now included:
World, Africa/Middle East, Asia/Middle East, Central/South America, Europe, North America, Oceana, United States, USA-Midwest, USA-Northeast, USA-Mid Atlantic, USA Southeast, USA-South, USA- Southwest, USA-Northwest, USA-Central, Germany, U.K.
Note: to alter the "DUMMY" on any of the graphs to resize the bubbles on each sheet individually, right click on the graph and choose "Select Data" and it is the last point.
Let me know if there is a better place for me to upload the file:
https://docs.google.com/open?id=0B9i...UJocGdGaDRJakE
If anyone wants to continue expanding this file, the best way to get maps of the correct format (straight longitude and latitude) is to find a huge map on google and crop it to the area needed if you cannot already find one of the area you are looking for. Something else to look at is a more efficient macro so more locations can be updated faster (there is a 256 cap on locations with a bubble graph).




Reply With Quote

Bookmarks