Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: World Map Excel Chart

  1. #11
    Junior Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0
    I have added to the workbook created by S M C to add views of regions. Now, there are graphs for:
    • World
      Africa/Middle East
      Asia/Middle East
      Central/South America
      Europe
      North America
      Oceana
      USA
      USA-Midwest
      USA-Northeast
      USA-Mid Atlantic
      USA-Southeast
      USA-South
      USA-Southwest
      USA-Northwest
      USA-Central
      Germany
      U.K.

    I have taken out some of the duplicate graphs, but you can add those back from the original file by copying them in. I have changed a couple of sheet labels in the macro, but the rest is the same way as S M C wrote it.
    As far as upgrading it from here goes, I think making additional graphs for more countries/regions would be good, and creating a macro that can handle large numbers of locations. The plot currently has a maximum of 256 points, so finding a way to add more would be good as well (maybe overlaying multiple plots).

    Here is the file:
    https://docs.google.com/open?id=0B9i...UJocGdGaDRJakE

  2. #12
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi danderson2692,

    Welcome to ExcelFox !!

    If you could attach excel files of different versions, that would be great.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #13
    Grand Master
    Join Date
    Apr 2011
    Posts
    22
    Rep Power
    10
    danderson2692, great work with the charts mate. Loved the initiative. And yes, thanks for sharing it here.

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
  •