Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: World Map Excel Chart

  1. #1
    Grand Master
    Join Date
    Apr 2011
    Posts
    22
    Rep Power
    10

    Lightbulb World Map Excel Chart

    Alright, I have been working on this assignment, and came up with a nice looking Chart representing all the countries of the globe. Pretty fascinating and intriguing at the same time. Thought this would help the community a great deal. Anybody interested, please put in a post.

    World Map Chart.jpg

  2. #2
    Junior Member
    Join Date
    May 2011
    Posts
    14
    Rep Power
    0
    Hi, SMC

    It would be great to see that project.

    Thank you.

  3. #3
    Grand Master
    Join Date
    Apr 2011
    Posts
    22
    Rep Power
    10
    Thanks for the interest Obed. Here's attached the working version. I don't think anything beyond a bubble chart or a scatter chart would be used. So I have coded for the macro to work on both the chart types.
    Attached Files Attached Files
    Last edited by S M C; 07-09-2011 at 04:48 PM. Reason: Missed Attachment

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi S M C,




  5. #5
    Junior Member
    Join Date
    May 2011
    Posts
    14
    Rep Power
    0
    Sam, is an interesting job, thanks for sharing.

    Grettings.

  6. #6
    Junior Member
    Join Date
    Jul 2011
    Posts
    1
    Rep Power
    0

    Your map is very beautiful, and useful.

    I have been teaching a similar class for a long time. See http://www.lulu.com/product/ebook/ge...excel/15308990.

    But, I LOVE yours. It is perfect for the highlevel view that many executives require.

  7. #7
    Grand Master
    Join Date
    Apr 2011
    Posts
    22
    Rep Power
    10
    thanks a lot know_ware....glad it help..

    Felt the same way about the charts in your site too..... interesting methodology....

  8. #8
    Grand Master
    Join Date
    Apr 2011
    Posts
    22
    Rep Power
    10
    know_ware, could you post a working sample here?

  9. #9
    Grand Master
    Join Date
    Apr 2011
    Posts
    22
    Rep Power
    10
    I have been getting PMs from members who were interested in the World Map Chart. One of the recent queries I received seemed like one that is generic, and a lot of members may be interested to know. I'll quote the query here, without refering to the usedname.

    Hi S M C,
    I saw your post of the world map (which is awesome) and am wondering how you were able to locate the countries based on longitude and latitude? I can see how you linked the bubbles to the columns of the "DataBase" tab, but I cannot see in the code where you placed the bubbles. I am trying to make a map of the USA and to make it easier for future changes, I would like to be able to add in the longitude and latitude to place the cities instead of manually placing them. I am fairly new to excel, especially vba, so I am not sure if I should even attempt this.

    Thanks in advance.
    Hi,

    You can find the code in the macro editor. If you need to go in to the lines step by step, open the workbook in macro disabled mode. Search for the line
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    and below that add
    Code:
    stop
    . Save and reopen the file in Macro enabled mode.

    Now, when you add or remove a country, you will get in to the code. You can now hit F8 to run through each line of code.

    On the longitude and latitude, for this to work, you'll need an exact fit to scale map that precisely represents the geographical landscape. You'll then need to fix the chart axes based on the position of the map (which means the starting and ending latitude and longitude of the map, since you are looking to plot a country). I on the other hand have used -180 to 180 and 90 to -90 since I was using the entire globe. So you'll have to figure that out. Plus, you may want to plot the states, so you will need the longitude and latitude of all the states within USA.

  10. #10
    Junior Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0
    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).

Similar Threads

  1. Heat Map
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 1
    Last Post: 01-02-2013, 02:57 PM
  2. Excel Chart into Word VBA
    By dhiraj.ch185 in forum Word Help
    Replies: 3
    Last Post: 12-26-2012, 11:23 AM
  3. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  4. Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  5. Correlation Map with color codes
    By Rasm in forum Excel Help
    Replies: 5
    Last Post: 12-04-2011, 08:28 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •