http://www.spc.int/prism/excel-to-time-series In order to link statistics to policy-based decision making, it is crucial to look at the time-series dimension. When looking at an Excel spreadsheet or a static chart, it is often easy to miss certain aspects of the trends - but with the use of the GapMinder animated time-series charts we are able to analyze the data in new ways. With this online Excel-to-Time-Series application, I wanted to simplify the process of producing these charts starting with the most common data file-type Excel, and ending with a simple web-page which you can own and share with the world through Email and Twitter. This application was part of an overall presentation: "Making Statistics Matter: Improved Access to Pacific Regional Information". (Delivered at the Statistics For Knowledge Conference held in Cape Town in December 2010.) Instructions:

  1. Choose Excel File with correct data format. i.e. First column is the name of indicator or category, and subsequent columns represent the years. Also please ensure all time-series values are numeric. For example:

You can also use the pre-defined World Bank data supplied via the "Import Example World Bank Data" Link, or go to the data catalog itself via the World Bank logo. Once you have chosen your Excel file, click Import Excel File and preview the same table on the web page itself.

  1. Choose a few indicators to compare by checking the relevant tick-boxes, and click Generate Chart & URL:

The resulting URL can then be copied and used in an email, or directly linked to your twitter account. Please also see the tutorial video via http://www.spc.int/prism/excel-to-time-series-tutorial James HemphillWeb DeveloperData Dissemination Specialist---------------------------------------SPC - Secretariat of the Pacific CommunityB.P. D5 - Noumea Cedex - New CaledoniaTel: +687 26.01.90Fax: +687 26.38.18---------------------------------------http://www.spc.int/sdp - jamesh@spc.inthttp://www.spc.int/prism

Built With

Share this project:
×

Updates