Advertisement

09.17.2008 at 09:42AM PDT, ID: 23739371 | Points: 500
[x]
Attachment Details

Is it possible to zoom in the background image on charts based on plot data ranges?

Asked by khott13 in Microsoft Excel Spreadsheet Software, Microsoft Visio

Tags: , ,

Hi all,

I have a map of the world and am plotting locations by geodetic coordinates onto it. Is it possible to have the map zoom in to a specific region of the world if there is only plot data in that area, sort of like a zoom fit option?

For example, there is a computer network that is only contained within the US. Instead of plotting the data on the background image of the entire world, the background image would zoom in so that it would only show the US.

The map is an Equirectangular-projection, so I imagine that the coordinates of the plot data could be correlated to the image size by scaling.

Any ideas if this would be possible through a macro?

Thanks,
KyleStart Free Trial
Attachments:
 
Equirectangular-projection.jpg (1017 KB) (File Type Details) 
Equirectangular map
Equirectangular map
 
[+][-]09.24.2008 at 12:06PM PDT, ID: 22562921

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.28.2008 at 10:50PM PST, ID: 23058803

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 / EE_QW_2_20070628