trouble with choropleth map of Belgium in Excel

[Tom_Smet]

Hi, 

I'm try to make a choropleth map of Belgium in Excel. I only need the provinces. No matter what I do, Excel will not put data in Brussels. I've tried, 'Brussel', 'Brussels', 'Bruxelles', 'Brussels Hoofdstedelijk gewest', ....

All other provinces work after I titled the column 'Belgische provincies' (belgian provinces).

Does anybody know how I can solve this?

[#2]

@Tom_Smet Same problem here, no real solution yet. It is however possible to show data on a higher level (Gewest) - with data for "Vlaanderen", "Wallonië" and "Brussel", you get a choropleth map with "Brussels Hoofdstedelijk Gewest" as a label.

Crazy twist: if you omit a country column with "Belgium", and only put "Provincie" in the column title (without "Belgische"), data for the 10 Belgian provinces and the Brussels Capital Region generates a choropleth map with only three areas: the Brussels Capital Region, the Luxembourg Kanton and the Dutch province of Limburg. Apparently, the Brussels Capital Region is a foreign province ...