Carte des départements français

%3CLINGO-SUB%20id%3D%22lingo-sub-1380024%22%20slang%3D%22fr-FR%22%3EMap%20of%20French%20departments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380024%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EI%20try%20to%20make%20chloropleth%20maps%20(2D%2C%20not%203D)%20of%20French%20regions%20and%20departments%20in%20Excel%20365.%26nbsp%3B%20For%20regions%20it%20works%20but%20not%20for%20departments%20because%20Excel%20does%20not%20recognize%20the%20names%20of%20departments.%26nbsp%3B%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1380024%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382292%22%20slang%3D%22en-US%22%3ERe%3A%20Carte%20des%20d%C3%A9partements%20fran%C3%A7ais%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663421%22%20target%3D%22_blank%22%3E%40Jacques_Friggit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20very%20depends%20on%20how%20you%20organize%20the%20data%20and%20name%20the%20columns.%20I'm%20not%20familiar%20with%20the%20geography%20of%26nbsp%3BFrench%2C%20sorry%2C%20took%20departments%20from%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FDepartments_of_France%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fen.wikipedia.org%2Fwiki%2FDepartments_of_France%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EIf%20rename%20columns%20major%20part%20of%20departments%20is%20shown%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190903i5860AA4815E11331%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Edidn't%20dig%20what's%20wrong%20with%20couple%20of%20them%20with%20no%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408101%22%20slang%3D%22fr-FR%22%3ERe%3A%20Map%20of%20French%20departments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408101%22%20slang%3D%22fr-FR%22%3E%3CP%3EThank%20you%20very%20much%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20even%20make%20the%20map%20you%20show.%3C%2FP%3E%3CP%3EEnclosed%20is%20a%20data%20file%20similar%20to%20yours%20(copied%20from%20Wikipedia).%26nbsp%3B%20Can%20you%20tell%20me%20why%20it%20doesn't%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJ.%20Friggit%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1409268%22%20slang%3D%22en-US%22%3ERe%3A%20Carte%20des%20d%C3%A9partements%20fran%C3%A7ais%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1409268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663421%22%20target%3D%22_blank%22%3E%40Jacques_Friggit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20shall%20build%20the%20map%20on%20all%20columns%2C%20not%20only%20on%20Departments%2C%20plus%20column%20names%20are%20to%20be%20changed%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20985px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193608i299B1A688B8D3453%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ECouple%20of%20departments%20are%20still%20not%20recognized%2C%20but%20I%20didn't%20dig%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416274%22%20slang%3D%22fr-FR%22%3ERe%3A%20Map%20of%20French%20departments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416274%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3CP%3EFor%20the%20two%20unrecognized%20departments%2C%20it%20is%20necessary%20to%20add%20%22department%22%20in%20front%20of%20their%20name.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJ.%20Friggit%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416373%22%20slang%3D%22en-US%22%3ERe%3A%20Carte%20des%20d%C3%A9partements%20fran%C3%A7ais%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663421%22%20target%3D%22_blank%22%3E%40Jacques_Friggit%3C%2FA%3E%26nbsp%3B%2C%20great%2C%20thank%20you%20for%20the%20update%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429857%22%20slang%3D%22fr-FR%22%3ERe%3A%20Map%20of%20French%20departments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429857%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663421%22%20target%3D%22_blank%22%3E%40Jacques_Friggit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20do%20you%20mean%20by%26nbsp%3B%3C%2FP%3E%3CP%3E%22For%20%3CSPAN%3E%20the%20two%20unrecognized%20departments%2C%20it%20is%20necessary%20to%20add%20%22department%22%20in%20front%20of%20their%20name.%20%22Could%20%3CBR%20%2F%3E%20you%20give%20me%20(us)%20an%20example%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thank%20you%20very%20much%20%3CBR%20%2F%3E%20JM%20AMBROSINI%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour.

J'essaie de faire des cartes chloroplèthes (2D, pas 3D) des régions et départements français dans Excel 365.  Pour les régions ça marche mais pas pour les départements car Excel ne reconnaît pas les noms des départements.  Comment dois-je procéder?

10 Replies

@Jacques_Friggit 

It very depends on how you organize the data and name the columns. I'm not familiar with the geography of French, sorry, took departments from here https://en.wikipedia.org/wiki/Departments_of_France

If rename columns major part of departments is shown

image.png

didn't dig what's wrong with couple of them with no data.

Thank you very much for your reply.

 

I can't even make the map you show.

Enclosed is a data file similar to yours (copied from Wikipedia).  Can you tell me why it doesn't work?

 

Sincerely,

 

J. Friggit

@Jacques_Friggit 

You shall build the map on all columns, not only on Departments, plus column names are to be changed

image.png

Couple of departments are still not recognized, but I didn't dig that.

@Sergei Baklan 

Merci beaucoup.

Pour les deux départements non reconnus, il faut ajouter "département" devant leur nom.

 

Sincèrement,

 

J. Friggit

@Jacques_Friggit , great, thank you for the update

@Jacques_Friggit 

Bonjour,

 

qu'entendez vous par 

"Pour les deux départements non reconnus, il faut ajouter "département" devant leur nom. "
Pourriez vous me (nous) donner une exemple ?

Merci beaucoup
JM AMBROSINI

Bonjour à toutes et tous,

Je lis votre POST pour récupérer les départements et régions de France, je suis aussi intéressé par le POST, par contre je suis en "Microsoft Office Pro Plus 2016", aussi est ce réalisable, et avez vous eu une carte comme demandé ?

Merci pour les réponses

Avec Excel 2019 et 365, vous pouvez maintenant créer des graphiques choroplèthe

@Jacques_Friggit 

Re,

merci pour le retour sauf que je n'ai que la version

Philippe_CHATEAU_1-1629289902448.png

et ne pense pas que l'on puisse y rajouter le module "cartes" comme dans la version 2019.

Et n'ai pas l'intention de passer à 365 qui à mon avis est beaucoup trop cher pour l'usage fait

A+

 

 

@jmambroBonjour, je viens d'essayer en mettant "département" devant Alpes de Haute Provence (qui n'est pas reconnu sur ma carte excel) et ça fonctionne : 

"département Alpes de Haute Provence" ça fonctionne ! Merci beaucoup @Jacques_Friggit  !!!!