A crappy chart from the Straits Times. GIC looking to Asia, emerging markets

I’m going to take a potshot at the Straits Times on a chart I saw in the Money Section.

The chart was trying to compare GIC’s (Government of Singapore Investment Corporation) current asset mix to last year’s asset mix. It gave me an absolute headache. This is my list of grouses:

  • Weak title. What does “ASSET MIX” really mean? There is plenty of space to say “Investment Asset Mix of GIC. 2009 vs 2008″. Without a clear title, I had to spend time trying to understand the numbers to know what this entire graphic was about.
  • Confusing colours. Apparently, there was an unspecified “colour meaning” that I had to interpret. Not only I had to mentally process the pie charts, I had to decipher the colour codes from the list. By then, I had lost the overall message of the graphic.
  • Numbers are all over the place. Why separate the numbers to the extreme sides of the graphic? My eyes had to swing from side to side to make meaning out of it. They should have been placed close together.
  • Too many numbers. 50% of the numbers in the list were not involved in the pie charts. So why list them out? It dilutes the strength of the charts. Make them smaller or simply don’t use it.

This would be my version of the graphic done in Excel 2007.

Things I have done:

  • Avoided pie charts. Our eyes judge lengths much better than angles.
  • Labeled the data series and provided values right into the chart. Hence lists and even charts axis are not needed. This creates a more compact graphic.
  • Added commentary to give the chart a purpose and message.

This is my version of the data without the chart:

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Ugly Real Economic Growth Chart from Singapore Statistics.

Singapore Statistics have the most amazing numbers on Singapore. Anything on our country’s GDP to how many handphones we have on average can be found. But the folks from SingStats seriously need to improve their charts.
Take a look here (http://www.singstat.gov.sg/stats/charts/econ.html#econA)

I could hardly make any sense out of these charts. They seems to be just thrown [...]

Continue Reading

A 10 year Balance Sheet Dashboard

Imagine you are the new CFO. You took over the position in the new firm and you want to look at the firm’s latest balance sheet.

You’ll probably want to see the firm’s 10 year balance sheet history.  It will be tough to make sense of things. What if you have a balance sheet dashboard instead? It [...]

Continue Reading

Klipfolio, a beautiful dashboard software. Free!

I have always been a fan of Klipfolio (http://www.klipfolio.com). This tiny software features beautifully made dashboards that run on your desktop. It’s useful and very clever. Download it, try it. It’s a low risk way to see how dashboards can work and it’s FREE!

Continue Reading

2015 Prediction: Google Docs is the new MicroSoft Office!

I just tried out Google Docs over the weekend and I like what I see. Google Docs is Google’s online version of wordprocessor, spreadsheet, and presentation software similar to Microsoft’s Word, Excel, and PowerPoint programs.
Let me explain why you should pay attention to Google Docs. It might change your life by the year 2015!
Firstly these [...]

Continue Reading

PowerUp Workshop: Making Beautiful Excel Charts

What if you could turn a drabby Excel chart:

into something like this?

For many Excel users, there is a need to produce clear, concise and even attractive charts in Excel without using expensive software. What is lacking are the clear techniques to do so. Compelled by this need, AEternus has designed a PowerUp Workshop to show [...]

Continue Reading

Death by PowerPoint

Excerpts from our workshop & PowerUp Seminar: PowerPoint Design Ideas for the Non Designer.
It is a fact that most presentations suck, and they suck for many reasons.

This seminar is about how to create great looking slides. Making bad slides is easy and we have seen many. Making good slides is easy too, but you need to [...]

Continue Reading

A gallery of Beautiful Charts for Excel part 4

I saw these couple of charts from the Standard Chartered Bank website.
Things I like about it:

Fresh colour scheme. Blues and greens work well together.
Bold titles that explain the intentions of each chart.
Each chart has an Increase/Decrease call out to emphasize the conclusion from the data trend.
Overall it’s a format that is pleasing to the [...]

Continue Reading

A gallery of Beautiful Charts for Excel part 3

The New York Times has the best illustrated charts I have ever seen. They are visually clear, easy to understand with good copy writing to explain the message behind a story. Note the use of blues and orange shades to give visual contrasts.

Continue Reading

3 simple red bands gave this mess of numbers and charts structure.!

A gallery of Beautiful Charts for Excel part 2

I have scoured the web and magazines for beautiful charts designs that we can use in our Excel reports. This will be part of a gallery I am creating. Do visit this blog for regular updates.

Continue Reading

Black, white, red and blue. What drama!

A gallery of Beautiful Charts for Excel part 1

I have scoured the web and magazines for beautiful charts designs that we can use in our Excel reports. This will be part of a gallery I am creating. Do visit this blog for regular updates.

Continue Reading