You can browse all countries and a lot of predefined regions in DataPicta. However, sometimes you may want to create your own custom region by merging data from multiple countries. In this tutorial we will show how to create the BENELUX region by merging data from Belgium (BE), The Netherlands (NE), and Luxembourg (LUX). The BENELUX region is often used in economic and political contexts to refer to these three neighboring countries in Western Europe.
Lets start with the Netherlands
- Open the DataPicta app by going to app.datapicta.com (this will open separate browser tab).
- If you have used DataPicta before, click on 'New blank chart' in the menu in the top right corner.
- Click on the plus icon (+) next to 'Data'.
- In the 'Add data' dialog, click 'Use geographic data'.
- Choose 'Countries' as the preset.
- Now search for 'Netherlands' in the list of countries and select it.
This will result in a visualization of the Netherlands, although you might think something went wrong it did not. The Netherlands is a country in Western Europe, but it also has several overseas territories in the Caribbean. DataPicta includes these territories when you select the Netherlands. Let's fix that by removing these overseas territories.
- In the geographic data table, look for the provinces that correspond to the overseas territories
- Click on the trash can icon next to 'Saba' and delete this island the data table.
- Do the same for 'Sint Eustatius'.
- Above the data table, there is an icon to switch to the chart view, click it.
You should now have a chart showing data for the Netherlands only.
Now add Belgium
- Again, click on the plus icon (+) next to 'Data'.
- In the 'Add data' dialog, click 'Use geographic data'.
- Choose 'Countries' as the preset.
- Now search for 'Belgium' in the list of countries and select it.
- Since you already have a geographic dataset in your chart, DataPicta will ask you what to do with the new data. Choose 'Merge'.
Belgium does not have any overseas territories, so you don't have to delete anything this time. You should now see a chart with data for both the Netherlands and Belgium.
As you might notice, luxembourg is shown in the bottom right corner. But this is not the country Luxembourg, but rather a province in Belgium. So we still need to add the actual country Luxembourg.
Finally, add Luxembourg
- Again, click on the plus icon (+) next to 'Data'.
- In the 'Add data' dialog, click 'Use geographic data'.
- Choose 'Countries' as the preset.
- Now search for 'Luxembourg' in the list of countries and select it.
- Click 'Merge' to merge the data.
And there you have it, you have successfully created the BENELUX region by merging data from Belgium, The Netherlands, and Luxembourg!
