Forum Discussion

Tom_Smet's avatar
Tom_Smet
Copper Contributor
Mar 14, 2022

trouble with choropleth map of Belgium in Excel

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?

excel

1 Reply

  • Renaat_DB's avatar
    Renaat_DB
    Copper Contributor
    Jun 19, 2024

    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 ...

     

Resources