This is basically a one-dimensional scatterplot with icons—with some advantages. First, although the country labels are still there, we let each country represent itself—at its location in the graph—by its flag. More intuitive. Second, because we are using position—and not length—to encode the data, it becomes easier to check ranking within each category and across categories.
Lets build the graph in Excel.
First, I need to get the county flags into the worksheet.
1. Select the range C3:C7 containing the country names.
2. With the cells still selected, go to the Data tab, and then click Geography under Data Types.
3. Select the range C3:C7, and the Insert Data button appears. Click that button, and then click the Image field name to extract the flag of each country.
The worksheet should look like this: