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 SingStat 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 seem to be just thrown together with out any theme or purpose. After all the work of collecting the data, if you can’t present data in a useful manner, it’s simply a waste of effort.
I took up the challenge to clean up this miserable chart using Excel, and try to show that beautiful charts can be useful to convey data in a clearer manner.
The improvements I made:
- The distinct shape of our total economy is much clearer as an area chart.
- The Manufacturing and Financial sectors are reduced to scatter chart with drop lines. The trends can still be discerned yet is less noisy compared to the original version.
About Aeternus Consulting
Related Link: Aeternus Consulting Excel Training Courses Singapore
Aeternus Consulting offers an excellent workshop Storytelling with Data Visualization using Beautiful Excel Charts. This workshop is aimed at students visualizing thesis data, managers and analysts needing to communicate in a data-driven way and leaders informing their board to drive actions.
Related Link: Making Charts Beautiful with Microsoft Excel