This post explains how you can create a Statistical World Map in WordPress with the IPU-Chart Editor and your favorite spreadsheet editor (Excel, Numbers, Open Office) in a few steps.
Using the Example Data
The example data that displays when you open the IPU-Chart Editor for WordPress is already linked to the world map. Go to the chart definition and enter the following values:
When you press the ‘refresh’ button the countries listed in the data are colored according to their population (the first column listed in the value entry field):
To display the ISO-3166-1 numeric country code for a country just move the mouse over the country:
Adding New Countries
To add new data just enter the ISO-3166-1 numeric country code for the country to the row and enter your data (or text comments):
If you have a lot of data to edit you can use your favorite spreadsheet editor (Excel, Numbers, Open Office). Download the template containing all the ISO-3166-1 numeric country codes an import it to the spreadsheet editor.
After you are done with editing just save the data in a tab- or comma-separated (tsv/csv) version and copy the content in the data section oft the IPU-Chart Editor.
Adding the Generated Short Codes to the WordPress Blog or Page
You can every time preview the chart by pressing the refresh button right below the editor!
From now on it’s easy: The IPU-Chart Editor generates the necessary WordPress shortcodes for you. Just go to the Shortcodes tab, select the shortcodes (data- and chart shortcode) and copy them to your blog. The chart will show up at the place where the chart shortcode is located. The data shortcode can be anywhere in your blog (place it best at the top or bottom of your page).
If you have a lot of data or if you don’t like pasting the data inside your blog you can reference a data file with the chart shortcode. Enter the url of you tsv- or csv-file in the data tab for this. Consult the IPU-Chart User Guide for more information.
Find Your Data… if you don’t have it already
The World Factbook lists a lot of interesting data for all countries of the world! With the Open Data initiatives in many countries more and more governments publish their large bases of data on the Web. With some research on Google you will find a lot of interesting data!
Try the IPU-Chart Editor Online at this site!