How to insert a line into a column/bar chart in Excel

Hi all, previously I have some trouble inserting a target line into a column/bar chart in Microsoft Excel

It took me couple of hours to figure things out, and here you will learn how to do it in just a few minutes

lets say you would like to create a column chart which shows the exam results of the students in class 1.

First, you need to create the column chart from the data (exam results) you have

1. Highlight the data 
2. Choose Insert tab  
3. Click on Columnoption
4. Select Clustered Column from the dropdown menu

Now you have a column chart in blue colour

Lets move on to insert a target line in the bar chart, say the passing mark is 60. You want to draw a horizontal straight line at this point.

1. Create another table with the passing score (60 in this case) for all the students
   
2. Right click on the column chart, choose Select Data
3. At the Legend Entries box, select Add
4. Simply give it a name (we name it as pass) & series values remain unchanged (will change them later)
5. Click OK
6. The chart now has an additional set of data in red column
7. Now select the red column and right click, choose Change Series Chart Type
8. Click X Y Scatter on the left and select Scatter with Straight Lines (the red column will disappear)
9. Right click on the column chart again, click Select Data
10. Choose pass and hit Edit button
11. Enter Series X values & Series Y values by highlighting the data in the new table, then click OK (refer snapshot)
12. The result should be similar to this 
    

Thanks for your time, hope you like this tutorial

EndNote Citation Guide - APA style

We have learnt how to install EndNote plug-in on your computer

Now lets learn how to cite a journal/book in a Microsoft Word file in APA (American Psychological Association) style. The reason for choosing APA style instead of others is because it is the most commonly used and widely accepted in institutions and organisations

Follow the steps below to cite from Google Scholar:

1. Click cite on the book/journal/paper you referred to
   
   
   
2. Select import into RefMan (your pc will automatically save it)
3. Go to Endnote 3.5 (alternatively, you can click Go To EndNote Web in M. Word)
   
4. Move your cursor to Collect tab, select Import References
5. File: Browse the file you saved in Step 2
   
6. Import Option: RefMan RIS
7. To: New group (you need to enter a group name later)
8. Click Import button
9. Now you have imported the reference into EndNote, go to M. Word and cite it
10. Click on the location where you want to cite it in your M. Word file (usually at the end of a sentence)
11. Select Find Citation
    
12. Enter key words such as Author name or Title of the book/journal (one key word is sufficient), then hit the Find button next to the search box
13. Click Insert 
14. Finally done, it should look like this in your M. Word file

P.S. If you would like to cite a journal from other websites, simply export the citation (without abstract) and save as RIS format, then continue from step 3.

Hope you enjoy this tutorial!!

EndNote Plug-In Installation Guide

Hi all, remember we talked about plagiarism previously? Today we are going to install EndNote plug-in into your computer

I just surf through the web but there is almost nothing out there for beginners, so i think it is good to write a post about this topic

We would be using a software called ENDNOTE to automatically create a reference list in your Word file. By doing this, you don't have to type your reference 1 by 1, word by word, and end up spending couple of hours citing the references with errors here & there. 

Believe me, once you have grasp the basic rule, your life would be a lot more easier than you could imagine.

Follow the steps below to install EndNote plug-in:

1. Go to EndNote 3.5 website, create a new account for free if you don't have one.
2. Sign in and Look for Format tab 
3. Click Cite While You Write Plug-In
4. Click on Download Windows for Windows users
5. Run the setup file to install Microsoft Word plug-in in your computer
6. Once completed, open your Microsoft Word to check whether the EndNote Web is on your toolbar (usually at the end). You need to sign in before you can use it

We will start to cite a reference from a journal in the upcoming post.

List bfor bed

oK have finish listing what i have to do tomorrow

yes this is what the experts say, always write down tasks for the next day before going to bed

and you will feel like putting down your thoughts and have a sweet dream

will try to see whether it works

Earth day Woooh

Getting excited just thinking about getting a new hoodie soon

Yes human has hopes and this is what keep us moving on

It is a powerful tool to really drive people going on and on

Hope for something better for our earth, HAPPY EARTH DAY

Running Man smash Blue Monday

Oh having monday blues? Look at the bright side

We are doing good yesterday, so we should go on today

Think about it, it is Monday again, that means new episode of RM is coming out today

Yeah always think positively, RM is our support

In return, we support them with heart & soul

brand brand new

New day, new goal, new challenges

wake up in the morning my brain is filled with lots of stuff that need to be completed within the day

is it possible? yes i hope so

lets move on

i got a feeling... that today is gonna be a good day....

Running Man Solo Win Chart

Hi all

recently there is a chart that has been spread like crazy among RM fans - RM Solo Win chart

Among all Ace has won the most, following by Grasshopper, Sparta, Gary, Haha, Giraffe, and lastly Big nose who has zero win, yes big 0

However this is just until the current date, as time goes by there might be some changes and turnover, so lets keep fighting with them to top the chart

Cardio pain

One two one two

After an intense cardio exercise yesterday wake up this morning feeling the pain in my body

Is it a good thing? not sure but it feel really good after the exercise

Yeah lets bring it on next week

Betrayer Galllery

Betray seems to be a very common term in RM

yes if you watch it there are just a few of them in different episodes

sometimes people will think very unfair if the member he/she supports turn out to be betrayed by others and hate the betrayer

but they are just doing this to entertain the audience, RM is about betraying  ( really true in some episodes). It is just one of the common tactics being used

you can see there is a change in their facial expression after a member is betrayed, but just after that they are back to a family again.. It would never last long

so lets just enjoy the show, don't take it too serious, just have fun

Fight hard, work harder

Work hard 

Everybody need to work hard

For you own and your love one

Don't simply let go

Because you never know

When you will regret

Hwaitting Asia Prince.. Giraffe

Ok lets talk abit about Giraffe

His name is Lee Kwang Soo, born in 1985 and 28 years old now

He is the youngest among all RM members and also the tallest, about 191 cm in height

So he is known as giraffe because you can easily spot him in the crowd

Since he is the youngest in RM casts, he is always bullied by the elders but he never skip any chance in taking revenge, especially to Sparta and their quarrels is one of the highlights in RM

Also Giraffe Betray Betray came out because he is an expert in betraying anyone, everyone... He could hardly control his hands when other RM are revealing their backs to him, so he is also a dangerous man

Currently among all the female guests that appeared in RM, he has shown interest only to Yuri from SNSD, but quoting what Jae Suk said 'you two are impossible', it seems ambiguity for them

However, we still hope he can find his real love and lead a happy life and continues to bring more laughter to the world

Hwaitting Giraffe

Soo... the Giraffe

RM has been filming in some Asia countries recently and you could hardly imagine how popular they are before this

And more surprisingly Giraffe has the highest popularity when RM goes overseas

The reason is because he is the makne among the members? No, I don't think so

It is mostly because of his role, his personality and dedication

We are not celebrity and not playing any role in a variety show, but it seems to be more than difficult to actually shine in this industry

You have just huge competitors and you couldn't choose when you wanna be famous, the fans the crowd the people out there will do it for you

Maybe I should continue with a brief intro about Giraffe in the next post

Base de Ball

ok today we are going to talk about baseball

the reason for learning it is because of RM, yes RM again

basically baseball is a game played by 2 teams, the attacking & defending teams

the attacking team includes the batter/hitter (the one holding the bat) and base-runners

the defending team consists of the pitcher (the one who throw the ball) & fielders

to be continued...

ttak ttak ttak..Ttakji

today lets introduce you to an old korean game - ttakji

if you have been a die-hard fan of RM u should be very familiar with this game

how you play it?

first the player would need to create her own ttakji by using thick materials such as newspaper & cardboard. the next thing is fold it into a ttakji

next the player will throw her ttakji onto another ttakji (which is placed on the floor), if she is able to flip it, she wins and the opponent is eliminated

however there seems to be some technique in playing this game, sound interesting right?

go away lag

nowadays rarely online not because i am lazy but due to the lag lag line

but now is getting better and hope it would run smoothly ever after

when the line is lag it can really drive u crazy

so please don't do this to us

tech tech

nowadays human life just cant get away from technology

just walk out the street, almost everyone will have at least one handphone with them

at home, teenagers nowadays spend hours sitting in front of their pcs doing whatever they like

i would say this is the trend, whether you like it or not, just take it and go

Unreveal Potential

everybody is unique in this world

we might think somebody look incompatible but maybe he or she is just hiding his/her potential

in variety shows each member is playing certain roles and hold a certain position in making the film making

you can see there are the trouble-maker, playboy, bully, flower, etc etc

each of them should be different and usually there are no crossover

and due to their characteristics they couldnt reveal their true potential because variety is meant to be fun rather than winning all time

however sometimes when they reveal their "superpower" the audience will be totally surprised

tik tok tik

just slept few hours yesterday

dont know why nowadays cant really sleep that much, is it because of age?

many people will have an alarm in their minds, sometimes when it is the usual time of getting up, the alarm will automatically send a signal to the brain and call you up

dono whether this is sthg good or not

anyway gonna change my habit and try to sleep early

Busan, the next Santorini

Wow.. Just knew that the village in Busan is absolute beauty, and really looks like a colourful Santorini   where the latter is basically white and blue

How did i know that? from RM since the members were there with Ji Woo for the last episode in 2012

Many people dream to visit Santorini once in a life time but no one ever dream to go Busan

feel weird, but anyhow both places are nice, so you can start planning your trip from today

have a look at the pic below, this is what Santorini looks like, i dont have any pic of Busan since i have not been there before, but hope will have a chance to

Infinite Challenge day

Hmm Infinite Challenge day

why said so

hehe because i was just watching it but i still dont understand how the story goes on

maybe this has to do with my IQ but anyway since this was just the 1st episode there is nothing to worry about

i might get to know the members and the story when time goes on

what is Baseball

Just learn baseball but could i really say that i understand it, dont think so

still far away from that

one of the best way to actually learn it is by watching the league or take part in the sport itself

but these 2 options seem to be impossible at the moment

hmm.. any other ways....

learning from the movie?

watching RM but don't really understand the rules of the game

usually when you are watching a movie, lets say a football related movie, do you understand the rules of the game? or do you just watch it without knowing anything about it

for me i prefer to understand at least how the game is played and how the scores is calculated besides some of the simple rules

but sometimes it is hard to get to know every single details because even if you could find it somewhere, it might be too lenghty to read all the rules from 1 to 100 and really understand each of them

or maybe we are not used to the game, some words and terminologies are just first time strangers to us, and it takes time to digest and remember them

but anyhow, it is good to learn while watching, at least you gain some extra knowledge bit by bit

the gamer, the player

Sometimes we heard news from others or read from the newspaper, we feel sad and sorry for what is happening out there

human has evolved for thousands years, maybe longer, but why such stupid human behaviour still exists and it lets us think about peace, law, fairness.....

what can we do? what are our responsibilities as human beings? what we are capable of? can we really change the world?

no one knows, but there are always rules in the game, we are the players, and we learn to play better in the game as time goes by

wonder why

Winter is over, not sure whether this is a good news or not

recently when looking out from the window, the sky is gloomy and raining always take place in the evening

maybe this is good for the farmers but bad for others?

does it mean that anything happen in this world will affect some people in a good way while the opposite to the rest?

i am not sure about this.. i only know that there must be a reason for that

lazy afternoon

Just finish chatting and feel so tired without any mood to work

maybe should stop here and have some rest or do something i enjoy

usually feel very lazy after having a meal

maybe i am so used to it

gonna change it? dont think so hehe

WGM couple - yet another double J couple

Initially I thought this couple is gonna be boring, but it turns out quite well and I am falling in them as well

They are Jo Jung Chi (male) and Jung In (female), yes they are the 2nd double J couple in this season

Jo Jung Chi is famous of playing guitar, his style and his laziness (really lazy if you watch it haha), and Jung In is not a stranger if you love Leessang, because she collaborated with Leessang in few songs and her voice is really fantastic.

I got to know her from the absolute beautiful song <<The girl who can't break up, the guy who can't leave>>

They have known each other and been together for 11 years, and maybe is good to learn from them on how to maintain the relationship with your love one and maybe you can foresee how you and your couple would look like after being together unmarried for 11 years

WGM couple - double J

Ok here comes the first couple that caught my attention in this WGM season

Yes here they are, cute couple double J
Jinwoon from 2am (a korean band) and Joon-hee, a famous korean actress

despite the age difference of 6, they look good together and both of them are really tall, 172cm for Joon-hee and 185cm for Jinwoon

If you are falling in love with some younger guys, this is a must watch

So if you have not started watching their episodes, don't miss out the right time to do so

Hwaitting

WGM?

Nowadays just continue watching We Got Married (WGM) another korean variety show

Felt that this season the couples are more of my interest compared to previous one

Maybe should do another post for the newly wed couples

Lets think about it

light exercise

Dont know what happen to me, woke up a few times last night

and can feel the soreness in my body

maybe need more light exercises to have a better sleep at night

ok will do it today

basic instinct of Running Man

Just watching running man again, and felt that throughout the 2 years of training, running girls and men are getting power up and their way of thinking and sensing are totally in FBI-compatible-mode

Just like in the hide-and-run or mouse-and-rat or whatever u named it, the running men could only know someone is coming by listening to the 'ring ring' sound from the bells previously, but now they are able to tell who is approaching solely based on the footsteps, isn't it amazing?

I bet this is what we called basic instinct, and the process of acquiring it is via practise, practise & practise

because practice always makes perfect.

crying for the mistage

Errrrhhhhh.. Just miss 1 step, 1 important step then everything has to be redo

I spent 1 hour sitting in front of the computer to work it out, but the system refresh everything when I click submit

Then I end up spending another hour doing the same thing again, cry....

but think about it, we have the chance to redo something which goes wrong, we should be grateful

when we dont have such opportunity to make thing right, or in life there are times that cant be redo, so grab the opportunities to do the right thing, but make sure you follow the steps carefully

why there is a cage

A bird that is closed in a cage, is similar to a person jailed in the prison

Freedom, is so near yet so far to most people

when you are small you know nothing and you are guided step by step

as an adolescence you are in you are focusing in your studies and people rebel for freedom

after you graduated you start to find a job and your mr or mrs. right

when you are at your mid 30-40 you create your own family

seems like the script is well written, most people just take and go, but one day when you look back, actually freedom is everywhere, it is just how you take it in your life

Stupid strategy

Just realise sometimes companies do sell their products with very good strategy, but not efficient at all

What is the point of inventing a 100% strategy but only applicable for a small portion of the same products?

it doesnt make sense at all. you just lost your customers in seconds, your marketing strategy is a total failure

Sop..

fighting gogogo

Today must work hard

gonna do as much as i can

had a nice breakfast and preparing my work

the sun is out the weather is nice 4 degree celcius today

lets rock n roll

here comes again.. laziness

Oh.. just end up doing nothing today

Feel energetic this morning but suddenly the work is not progressing as predicted plus some interference have caused me to stop my work

erhh.. angry on myself, but since there is no turn back, just enjoy for today, tomorrow gonna be a nice day

new vs old

Seems like technology development has made human life easier

However some computers or websites functions have been the other way round, they become more complicated and less human friendly

Yes I understand you need to upgrade the system server or whatever you called it but people are getting used to the previous fast and easy way of getting works done, unless you are able to come out with something more efficient in term of time consuming and really easy to operate, otherwise i see no reason why you should change it when the cost is the same

Maybe you mean to try it out but if lets say it doesnt work as it should be, change it to the older version will be much grateful

There is always an option. New doesn't always mean good

Thank you Gary

There are always some events you would like to forget

There are some scars and wounds you would like to heal

There are time you feel so down & desperate

Music is a remedy for all

The passion for making music live in them

They make music for some reasons

Confuse

ever feel like not going to do anything for the day?

yes there are plenty to be done, just that don't have the mood to start

maybe because engine is overheat, maybe it is not a bad idea to cool for 24 hours

however waking up in the next day will make me feel uncomfortable due to the work carry over from yesterday

so what should i do? Really confusing

Running Man support

Watching Running Man now

Just noticed that there are actually many fans out there waiting for Running Man to air every week

Maybe this is a way to get rid of monday blues

Anyone still have not started your journey watching it?

Do start today, it is not too late

Stress!!

Yesterday slept quite late, today wake up so early ==

not that i dont want to continue sleeping but it was the dream that woke me up suddenly

after some cool down i think it was due to the high pressure

maybe i need to find more effective ways to cope with my stress

any suggestion?

What is your choice, Kang Gary

Mr. Kang,

It was 2 years back since the rumor started to spread across the globe

The born of the ultimate Monday Couple from Running Man

Over the months and years the couple receive continuous supports and likes from fans all over the world, from men to women, from young to old

However they have come to the time when they have to say goodbye to this relationship, although thousands and millions out there are urging "please, don't"

No matter how it goes, we still have a great time watching them together, even though it only happened on Monday (yet some exceptions)

Yet another fighting day

Although today is Sunday which meant to be rest day, but life is full of challenges

We must try our best to be well prepared, so when the opportunity is right in front of you, you could grab it without letting it slip through your hands

Rest to go further, but learn whenever you are, there is no limit

Hwaiting!!

What do you learn from Running Man?

Yes I know you have been watching Running Man for days, for months, for years

But you are just watching it for fun without learning anything?

How is it possible? Even someone as dumb as me learn so many..

Don't believe me? I will prove it to you, now listen carefully:
- never trust anyone in Running Man
- never think of shacking hand with or hug a young female guest
- never let your guard down
and there are just more than these..

And remember, learn as much as you can, you might need them in your life one day

Have a nice weekend!!!

咚咚

时常从电影和电视剧里看到，从小就喜欢的咚咚却因家庭经济能力有限而无法购买

几10年后出来社会工作后，经济能力也比较自由了，往往想起小时想拥有的咚咚，却因为停止生产而无法再拥有了，可能连照片也没半张，只能从残留的记忆中去回味咚咚的模样

人生往往也这样，喜欢的咚咚却因为一些局限限制而没办法去得到，春去秋来，如今的你已经有那个能力了，咚咚却再也无法投入你的怀抱，换来的只是一阵唏嘘

Citing a reference - part 1

Continuing from the previous post regarding plagiarism, I would like to introduce a software that could help you cite references easily from journals

Search 'Endnote Web 3.5' in google, or click on the link below
https://www.myendnoteweb.com/

Next, you would need to sign up for an account, just enter your email address & password etc..

ok now you have an endnote account, we will learn how to cite a reference in the next post

What ?? Plagiarism

Not sure how many of you guys are aware of plagiarism?

Students and workers might come across this when writing their reports

Plagiarism is a serious offence and the only way to avoid it is by citing the reference when you are referring to others' ideas, thoughts or languages.

Nowadays there are some tools available and widely used to determine whether a piece of work is original or not, so don't play with the fire, you might get burnt

If you are not aware of this, please starting from today, learn to cite and show some respect to the original authors. Credit always goes to them

Life

Today is Thursday, seems like Easter break is over, most people have started their working life

Life isn't easy for everyone, it is full of challenges

However, many are working hard to lead a good life, not only for themselves but also for the loves one

Never let yourselves down, there must be a reason why you are here

Print anything you want. Are you ready for it?

Today human life would be different without science & technology

Currently the world is moving towards personalization, meaning you could create something that is unique in the world and different from others

How is it possible?

3D printing is making this feasible. A 3d printer is able to 'print' anything as long as you could draw it using specific software 

Most manufacturers are aiming the market for Personal 3d printers which are suitable for home used. this mean you can just print the model at home anytime you want, all you need to do is design the object or purchase the design file online, the printer will do the rest for you

Sounds fantastic right? Are you ready for it...

Tribute to the Moonwalker

Just listen to Earth song sang by one of my favourite singer, Michael Jackson

I couldn't remember since when I like his songs

Not only that, his dance is also a all time favourite. So many people and artists imitate Michael dance and move, among all Moonwalk is the most popular one

Try to watch some of his performances and concerts, the reaction of his fans was really awesome, and everytime there were fans being carried away by the security teams due to some reasons, and this record is still unbeatable

Don't forget he was also the first artist who 'invented' MV so you could easily watch his performance at  home instead of solely listening to his mega hits

Exercise

As promised to myself, I just finish exercise and feel so so tired right now

Although tired to move around but really refreshing

The brain suddenly function so smoothly that I can think so efficiently (I am not retarded though)

Yeah I tell myself to keep it on for next few days, must push to the limit

GOgogo

Microsoft Project

Today I spent about half of the day learning Microsoft Project

Most of the Microsoft users should have this software in their computer

It came together with other Microsoft Office package such as Word and Excel which I think are the most common among users

M. Project is a useful tool if you would like to plan or manage your schedule for a project, not a trivial one but a large scale project in which it will take few months time

Why shouldn't I plan my schedule using M. Project for a mini project? Imagine you are going to make a cup of coffee, you probably wouldn't want to spend hours (or minutes) to create a comprehensive schedule including all the tasks and resources right?

What you want is just make the coffee in 15 minutes and enjoy it with your love one

However if the project is a huge one and involving many resources (human included), you should try this tool, or there are still many project management software out there but this is not the aim of this post so we will just omit it

There are some useful tutorials on the internet and you can learn to use it within hours if you have the patience.

Enjoy mate!!

opps 怎么办

今天一起生，腰酸背痛

是不是人上了年纪都会如此（说到好像很老将）

上网看了看，应该要多运动才行，好我决定今天就开始运动

不过要做什么运动比较适合，头痛

如今人类的生活已经离不开网路了，一有什么疑难杂症都是靠他来得到咨讯，跟朋友家人联系也是靠他，甚至闲着无聊都回用它来打发时间

万一有一天网路封锁了，后果将会是如何，真的难以想象

努力今天，辉煌明天

今天又是忙碌的一天

虽然放假不过却有很多咚咚等我完成

虽然很累，不过无论如何都要坚持熬下去

要知道这世上很多人都为了每分每秒在努力生活

如果每个人都放弃，那么明天将是如何，下一代将怎么办

大家准备好了吗，一起冲啊~ ~ ~

山穷水尽疑无路，明天睡醒又一春

人生可以从来吗

人生很奇妙。

以前当一个人喜欢你时，明明有感觉，却总是左挑右嫌，甚至鸡蛋里挑骨头，结果他跑了

几年后，又有一个喜欢你的人出现了，自己也喜欢，不过却因为一件芝麻绿豆的小事而分手了

过不久他慢慢的进入了我的世界，可是最后却因为自己的执著而各奔东西

如今已经没有联络，不过相信他们都过得幸福快乐，照一照镜子里的自己，已经不再是18岁卜卜脆了

每当走在傍晚的小巷时，孤独的影子总是伴随，散不开，离不去。。

Cutting hair isn't as simple as you think

Last Saturday went to the barber shop but the bus has changed new route and I have been sitting in the bus for more one and a half hour.. OMG

then I went again on Monday but due to Easter holiday it was closed, What the..

Again I try my luck today (it is getting more serious now) and went to the shop this morning, WOW, it is open and I finally completed one of my main task in 'to do list during Easter break'

Fantastic Baby..

Fooling Day

Today is April fool's day

erm as I mentioned before I dont really celebrate it

there is nothing to be fool about, at least this year I am not fool by anyone today haha great improvement keep it up

I think I should have learn some skills to fool others next time (really weak in this, not talented..)

For my friends who has been fooled in this very special day congrats haha really too bad but cant stop myself to laugh

Anyway enjoy yourselves, yeah

你blog了吗?

刚开始玩部落格，觉得很不错，毕竟是不同于平常的体验

在部落格里，你就是主角，你可以分享任何体验




可是我看了看，身边也没多少人在玩，这是什么原因呢？

也有的朋友刚开始很有兴致的写，不过往往到一半就半途而废

不过只要部落格经常有客人来访，肯定是对lz的一大推动力

通过部落格，你可以让全世界的人民通过文字图片认识不一样的你

把自己的生命写成故事，把那一丝丝的甜蜜写成日记，把所知所学散播出去，把一切的一切都和大家分享

朋友们，你准备好玩部落格了吗？

如果还没，可以按以下连接，几分钟内建立你个人的部落格
如何建立自己的部落格
成功后记得来交流哦