MAP CHART : the mystery of France

%3CLINGO-SUB%20id%3D%22lingo-sub-219151%22%20slang%3D%22en-US%22%3EMAP%20CHART%20%3A%20the%20mystery%20of%20France%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219151%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20for%20a%20couple%20of%20days%20on%20creating%20a%20map%20chart%20for%20France%20by%20%22d%C3%A9partements%22%20(or%20county).%20I%20really%20struggled%20to%20do%20it%20but%20thanks%20to%20this%20forum%20I%20found%20a%20solution.%3C%2FP%3E%3CP%3EI%20have%20to%20admit%20that%20the%20French%20territory%20is%20quite%20complicated%20to%20understand%2C%20and%20even%20more%20since%20last%20year%20with%20the%20creation%20of%20new%20regions%20(we%20have%20now%2013%20regions%20instead%20of%2022)%20and%20the%2095%20counties.%20Whatever...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20out%20that%20Excel%20didn't%20recognize%20the%20French%20word%20of%20%22Pays%22%20(Country)%2C%20%22R%C3%A9gions%22%20(Regions)%2C%20%22D%C3%A9partements%22%20(County)%2C%20that%20is%20why%20I%20struggled%20for%20a%20long%20time.%20And%20it%20wasn't%20working%20too%20in%20English.%20But%20it%20was%20working%20in%20Italian%20%3A)%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20changed%20the%20names%20of%20my%20column%20title%20by%20%22Contea%22%20(for%20Country)%2C%20%22Provincia%22%20(for%20Regions)%20and%20%22Regione%22%20(for%20County).%20And%20by%20a%20kind%20of%20miracle%20I%20don't%20understand%2C%20it%20was%20working%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBUT....%20there%20is%20always%20a%20but...%20It's%20working%20for%2094%20counties%20out%20of%2095.....%20A%20single%20county%2C%20called%20%22Lot%22%2C%20cannot%20appear%20on%20the%20map.%20Quite%20frustrating...%20I%20tried%20to%20find%20if%20this%20county%20had%20another%20name%20or%20spell%2C%20but%20nothing%20about%20that...%20so%20I%20tried%20everything%20like%20%22Le%20Lot%22%20%2F%20%22LOT%22%20%2F%20%22Lot-%22%20%2F%20%22Lott%22%20%2F%20etc...%20I%20said%20to%20myself%20that%20the%20closest%20county%20of%20%22Lot%22%20which%20is%20%22Lot-et-Garonne%22%20could%20maybe%20create%20a%20bug%20in%20the%20file%20but%20when%20I%20delete%20it%20the%20problem%20is%20still%20the%20same.%20AND%20THE%20%22LOT%22%20IS%20STILL%20MISSING.%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESooooo%20now%20I%20do%20not%20have%20any%20solution%20for%20this%20problem%20and%20I%20suggest%20that%20this%20county%20(I%20repeat%20%3A%20%22LOT%22)%20is%20missing%20in%20the%20database%20of%20Excel%20(guys%2C%20come%20on%2C%20you%20can%20do%20better...%20%3A)%3C%2Fimg%3E%20).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20join%20forward%20my%20file%20for%20all%20the%20french%20(and%20other%20people%20who%20need%20it)%20who%20struggled%20and%20never%20succeeded%20to%20do%20this%20map.%20And%20if%20SOMEONE%20HAS%20A%20SOLUTION%20I%20CAN%20PAY%20A%20LOT%20OF%20MONEY%20(Word%20game%2C%20got%20it%3F)%20to%20have%20it%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-219151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-267619%22%20slang%3D%22en-US%22%3ERe%3A%20MAP%20CHART%20%3A%20the%20mystery%20of%20France%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-267619%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20the%20solution%20%3A%20write%20%22d%C3%A9partement%20du%20Lot%22%20instead%20of%20%22Lot%22...%20and%20it%20works!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20file%2C%20this%20is%20exactly%20what%20I%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdouard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219187%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20MAP%20CHART%20%3A%20the%20mystery%20of%20France%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219187%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Dean%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20the%20best%20answers%20on%20this%20forum%2C%20told%20myself%20it%20was%20the%20best%20place%20to%20post.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20quite%20a%20newbie%20on%20this%20topic%2C%20could%20you%20recommend%20me%20some%20forum%20dedicated%20to%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I%20totally%20agree%20with%20you%20with%20PowerBI%2C%20I%20suceeded%20to%20create%20my%20map%20on%20it%20without%20a%20problem.%20However%2C%20I'm%20looking%20for%20a%20tool%20that%20all%20my%20colleagues%20could%20use%20and%20PowerBI%20is%20not%20known%20as%20Excel%20is...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219177%22%20slang%3D%22en-US%22%3ERE%3A%20MAP%20CHART%20%3A%20the%20mystery%20of%20France%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219177%22%20slang%3D%22en-US%22%3EI%20would%20recommend%20posting%20this%20question%20in%20a%20forum%20dedicated%20to%20Excel.%20You%20may%20also%20want%20to%20look%20at%20PowerBI%2C%20it%20provides%20a%20lot%20of%20solutions%20to%20problems%20like%20this.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi guys,

 

I'm working for a couple of days on creating a map chart for France by "départements" (or county). I really struggled to do it but thanks to this forum I found a solution.

I have to admit that the French territory is quite complicated to understand, and even more since last year with the creation of new regions (we have now 13 regions instead of 22) and the 95 counties. Whatever...

 

I found out that Excel didn't recognize the French word of "Pays" (Country), "Régions" (Regions), "Départements" (County), that is why I struggled for a long time. And it wasn't working too in English. But it was working in Italian :) 

So I changed the names of my column title by "Contea" (for Country), "Provincia" (for Regions) and "Regione" (for County). And by a kind of miracle I don't understand, it was working !

 

BUT.... there is always a but... It's working for 94 counties out of 95..... A single county, called "Lot", cannot appear on the map. Quite frustrating... I tried to find if this county had another name or spell, but nothing about that... so I tried everything like "Le Lot" / "LOT" / "Lot-" / "Lott" / etc... I said to myself that the closest county of "Lot" which is "Lot-et-Garonne" could maybe create a bug in the file but when I delete it the problem is still the same. AND THE "LOT" IS STILL MISSING. :(

 

Sooooo now I do not have any solution for this problem and I suggest that this county (I repeat : "LOT") is missing in the database of Excel (guys, come on, you can do better... :) ).

 

I join forward my file for all the french (and other people who need it) who struggled and never succeeded to do this map. And if SOMEONE HAS A SOLUTION I CAN PAY A LOT OF MONEY (Word game, got it?) to have it :)

 

Thank you for your help.

3 Replies
Highlighted
I would recommend posting this question in a forum dedicated to Excel. You may also want to look at PowerBI, it provides a lot of solutions to problems like this.
Highlighted

Hi Dean,

 

Found the best answers on this forum, told myself it was the best place to post.

 

I'm quite a newbie on this topic, could you recommend me some forum dedicated to Excel?

 

And I totally agree with you with PowerBI, I suceeded to create my map on it without a problem. However, I'm looking for a tool that all my colleagues could use and PowerBI is not known as Excel is... 

 

Thanks,

Highlighted

Hi, 

 

I found the solution : write "département du Lot" instead of "Lot"... and it works!

 

Thank you for the file, this is exactly what I needed.

 

Edouard