#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Colorizing countries

I know what I want to do, but unfortunately I don't know if it's possible or
not, so I'm grateful for any indicator of whether I'm being completely
unrealistic or not.

Basically I want to be able to color in images of countries on a map, with
the colors being based on data in an excel range. There are a couple of ways
I've tried to approach the problem, but I haven't been able to find a
reasonable way of actually achieving my goal.

- I have no problems with setting up a VBA function to change the colors of
shapes on a work sheet - the only problem is that I don't have any shapes
that look like countries. Is it possible for me to create new custom shapes
to use in excel directly from existing vector graphics?

- Another alternative is to use Excel's functions for colorizing images -
this doesn't seem likely to produce as good results, and I don't know the VBA
code for colorizing images.

- The final alternative, which seems most attractive but is completely
beyond me is to integrate Excel data and SVG-files. All the countries of the
world are available as SVG files - is there some simple way I can input data
into excel and use it as the basis for an SVG fill or border? This would be
the preferred choice.

Do any of these seem like a viable path? How would I best go about trying to
solve my challenge?

Thanks for your input.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formatting in different countries Libby Excel Worksheet Functions 5 May 11th 08 09:41 PM
Problems using Excel from different countries Jose Mourinho Excel Discussion (Misc queries) 1 June 14th 07 12:52 PM
Using Excel in different countries Giri Excel Worksheet Functions 3 November 19th 05 01:31 PM
world countries zaifi Excel Discussion (Misc queries) 1 October 12th 05 09:17 AM
Maps of countries of the World. Carl Michael Jewitt Excel Worksheet Functions 1 August 19th 05 04:22 PM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"