How to create a customizable city map in excel

**lymphomaniac** · 07-03-2010, 08:41 AM

Hey,

At work for presentations I often have to add a selection of cities to a map of my country (Russia). Generally I do it manually in paint or send it to the graphics dept. I was wondering if there was a way to automate the process through Excel, where I have a country map and a selection of 100 largest cities and I could just choose the 10-30 I need and have the dots and the names added to the map?

I have basic-intermediate knowledge of Excel but more than ready to learn.

Thanks in advance for your help.

**pike** · 07-03-2010, 09:18 AM

Hi lymphomaniac
Welcome to the forum
This site may help
http://processtrends.com/pg_google_earth.htm

**Andy Pope** · 07-03-2010, 09:20 AM

It really depends what you customizing looks like.

If you are just adding push pins to a map with maybe a textbox for some extra information then maybe you could use a xy-scatter chart. Your picture would be the plot area fill. The push pins would be the data series, so you just need a x and y pos. And finally data labels provide the textual info.