+ Reply to Thread
Results 1 to 3 of 3

Overlap map/chart

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Overlap map/chart

    Hello,

    I try to add a piece of map behind my chart, the map should be W30, N75, E060.
    What I want to achieve is a perfect overlapping of my chart with the map, I mean the location of my points (from chart) to be the same on map. Is it possible?
    I know that there are differences between map and chart scale, I tried a lot of ways but I have no idea how to do it. Could you help me, please?
    Thank you very much for your help.
    Attached Files Attached Files
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Overlap map/chart

    If you use the picture as the fill for the plot area then you just need to alter the min/max values of both scales to match that of the image.

    You can see that DUB is much closer to actual location by simply adjusting the scale.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Overlap map/chart

    Hi Andy, thanks again for your valuable help.
    I am not sure why I can not download the file attached, and this is not the first time when I'm facing with but I ignored it by now....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  2. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  3. Chart overlay / overlap
    By kuzna26 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-14-2013, 10:33 AM
  4. Chart start time for overlap
    By Mothman in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-04-2010, 09:20 AM
  5. overlap chart / venn diagram
    By kmool in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-25-2008, 06:27 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1