France map in Excel

Here is a link to the map of my clients as of 30/09/09:
http://www.mdouest.com/Carte_repartition_clients.xls

This is a file that I adapted from an excellent Excel help site!

The usage is quite simple: you take the postal codes of your clients, reduce them to the first two digits, and copy-paste them into column B of the "clients" sheet.

Column D of the Departments sheet gives you the number of clients per department; column E indicates which color code will be assigned to the department in question, based on the colors chosen by client occurrences in the Colors sheet, column B.

I am attaching other files for download, gathered from the internet and uploaded for the author of this post and those interested in the subject; I am grateful to their authors who had the good taste to simplify our lives!

http://www.mdouest.com/ExcelAdmin_MAP_V2-Travail.xls
http://www.mdouest.com/geoviewer.xls
http://www.mdouest.com/MAP_v1.zip
http://www.mdouest.com/mDF%20XLmap%20v2.0.xls

To work!

@+

Armel35

Hello,
I would be interested in checking your example. The link mentioned in your response is no longer active.
I have the same issue in finding the map of France to color differently based on the data in the spreadsheet.
Thank you in advance.
Best regards

ici http://gerard.g.pagesperso-orange.fr/logiciels/Appli/RegFrancV2.xls