Use Excel and Infogram to Analyse Data (WEEK 5)

On week-5, LJ and Rob have taught us the methods of using Excel and Infogram (infogr.am) to analyse data. This article will mainly focus on how to use infogram to create infographic after finishing the data calculation in Excel.

The data below is one of the practices we have done. It shows a record of the total amount of money that politicians have got during the 2005 election(6-month before/ 6-month after).

Six-month to the run-up:

Screen Shot 2014-11-13 at 15.38.03

Six-month after:

Screen Shot 2014-11-13 at 15.37.38

(Apparently before the election a lot politicians were making great effort to get donations.)

Infogram is an easy-used website, make sure getting an account first.

Just click ‘Create’ and choose ‘Charts’.

屏幕快照 2014-12-04 下午11.23.46

Select ‘Add Chart’ and ‘Double-click to edit'(see below).

屏幕快照 2014-12-04 下午11.25.31

Now all we need to do is choose a square(avoid the first column and row), then copy 5AB-16AB(Excel Sheet8) or 5AB-8AB(Excel Sheet7) to the blank square chosen area. The reason for avoiding first column and row is because they are the space for titles.

屏幕快照 2014-12-04 下午11.32.54

Tada! Here we are! The final infographics!

One of advantages of Infogram is that it makes all the data clear, also data are distinguished by their colours.

屏幕快照 2014-12-04 下午10.45.46

屏幕快照 2014-12-04 下午10.45.15

(Total words: 186)

Advertisements

2 thoughts on “Use Excel and Infogram to Analyse Data (WEEK 5)

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