Makeover Monday

Makeover Monday – New Zealand Tourism

Makeover & Original

Just a simple makeover this week! I wanted to include a map-as-filter section, but the file with the geographic coordinates couldn’t be opened by my personal freebie account, or by my work’s paid but version 9.3 account. I turned the bar chart into a line chart, and included each year instead of limiting it to the last three. I think this makes it easier to compare years and see the overall trend.

This viz is really very simple, but the underlying data has a lot going on. The region column includes “Total (all TLAs)” representing the entire country. Because the regional values are weighted for population, simply aggregating them would under represent larger, more populous regions, and over represent the smaller ones. Use the Total (all TLAs) rows to represent the entire country, and avoid aggregating the regions.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s