![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
Hi.
I have data for customers in the UK, all have a postcode, was wondering if there was some way of getting an UK map to display the density of customers in different regions? RET79 |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
UK map if you’re using the clip art, I seem this is the case, then no is the answer.
FIX. Microsoft will allow database data, ie customer records and these can be linked to show a little flag and this can be exported as a bmp or jpg, Would this not do a better job than you hopped? Update the database re run the merge statistic, and re save as you need. A good fix. Let me know I might be able to swing this one, but that might need you sending your entire data base to me, *this you might not like* no PROMISES I do not have version 2001 or 2002 Auto route UK to do this. ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||\ Late thought just as I was going to post I have a nasty feeling Visio also does this but some what different. Some help I hope.
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
Jack,
Thanks for your reply. I don't really have an urgency to go about this one as it happens, was just thinking was it a possibility for the future really. I have seen some do it with american states etc. you see so was just wondering if there was a similar thing readily available for UK. I'll get back to you on this sometime when I got a better idea what I want. RET79 |
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Hi RET79
No bother when you’re ready please email me - regardless ill still try to solve this more for myself than not, as you’re in no direct rush, but ill post / email if I get a fix… And go from these, I know this can be done – I’m sure I have the kit at work, no problems.
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|