Learned how to creat incell bar charts in excel 2007, and it’s so damn cool!!!
- First we will insert a column next to the total sales column and call it “last 12 months”. We will use this column to fill up the in-cell bar graph for the last 12 month sales.
- Next we need to normalize the sales values for each month to a value between 0 to 9. I have used linear normalization, ie the maximum value across the 12 months would be 9 and everything else will be normalized according this. The formula for one month looked something like this: =ROUND(jan_sales/MAX(all_sales)*9,0). Remember, we need to round the data make it one digit instead of a decimal.
- Once we have normalized values for each of 12 sales figures for each row, we just need to concatenate them to create a 12 character long string of numbers and place this values in our newly inserted column. P.S.: =concatenate(C2,…..J2) didnt find a quick way to do this….><
- Finally, we will change the font of this column to “bargraph” (just select all the cells under the “last 12 months” and change the font)
P.S.: I also found another way to do this, but that seems a bit dumb comparing to the inserting insell bar way: select the date from each mon, and simply click bar data..change the format of it, and that’ll give us a similar pic. Do it several times repeatedly based on the product data, and we will also have bar chart pics.
想當年 非常deadline fighter的時候 好像有好幾次明明都快到5點deadline還在糾結 怎麼把首頁不顯示頁碼 從第二頁開始神馬的…後來好像都放棄說 算了 打印兩次 再釘在一起好啦…
1. Click Page Layout–>Select Page Setup on the bottom of the column–>Click Layout–>Put a tick on “Different First Page” –>Click OK.
2. Click ‘Insert’ –>Select “Page Numbers”–>Select “Format Page Numbers”–>Starting at 0–>OK.
3. Insert Footer –>Select whatever style you want
4. Nailed it!!! Yeah!!
thirty things to stop doing to yourself: as maria robinson once said, “nobody can go back and start a new beginning, but anyone can start today and make a new ending.” nothing could be closer to the truth. but before you can begin this process of transformation you have to stop doing the things that have been holding you back. here are some ideas to get you started:
- stop spending time with the wrong people. – life is too short to spend time with people who suck the happiness out of you. if someone wants you in their life, they’ll make room for you. you shouldn’t have to fight for a spot. never, ever insist yourself to someone who continuously overlooks your worth. and remember, it’s not the people that stand by your side when you’re at your best, but the ones who stand beside you when you’re at your worst that are your true friends.
- stop running from your problems. – face them head on. no, it won’t be easy. there is no person in the world capable of flawlessly handling every punch thrown at them. we aren’t supposed to be able to instantly solve problems. that’s not how we’re made. in fact, we’re made to get upset, sad, hurt, stumble and fall. because that’s the whole purpose of living – to face problems, learn, adapt, and solve them over the course of time. this is what ultimately molds us into the person we become.
- stop lying to yourself. – you can lie to anyone else in the world, but you can’t lie to yourself. our lives improve only when we take chances, and the first and most difficult chance we can take is to be honest with ourselves.
- stop putting your own needs on the back burner. – the most painful thing is losing yourself in the process of loving someone too much, and forgetting that you are special too. yes, help others; but help yourself too. if there was ever a moment to follow your passion and do something that matters to you, that moment is now.
- stop trying to be someone you’re not. – one of the greatest challenges in life is being yourself in a world that’s trying to make you like everyone else. someone will always be prettier, someone will always be smarter, someone will always be younger, but they will never be you. don’t change so people will like you. be yourself and the right people will love the real you.
- stop trying to hold onto the past. – you can’t start the next chapter of your life if you keep re-reading your last one.
- stop being scared to make a mistake. – doing something and getting it wrong is at least ten times more productive than doing nothing. every success has a trail of failures behind it, and every failure is leading towards success. you end up regretting the things you did NOT do far more than the things you did.
- stop berating yourself for old mistakes. – we may love the wrong person and cry about the wrong things, but no matter how things go wrong, one thing is for sure, mistakes help us find the person and things that are right for us. we all make mistakes, have struggles, and even regret things in our past. but you are not your mistakes, you are not your struggles, and you are here NOW with the power to shape your day and your future. every single thing that has ever happened in your life is preparing you for a moment that is yet to come.
- stop trying to buy happiness. – many of the things we desire are expensive. but the truth is, the things that really satisfy us are totally free – love, laughter and working on our passions.
- stop exclusively looking to others for happiness. – if you’re not happy with who you are on the inside, you won’t be happy in a long-term relationship with anyone else either. you have to create stability in your own life first before you can share it with someone else.
- stop being idle. – don’t think too much or you’ll create a problem that wasn’t even there in the first place. evaluate situations and take decisive action. you cannot change what you refuse to confront. making progress involves risk. period! you can’t make it to second base with your foot on first.
- stop thinking you’re not ready. – nobody ever feels 100% ready when an opportunity arises. because most great opportunities in life force us to grow beyond our comfort zones, which means we won’t feel totally comfortable at first.
- stop getting involved in relationships for the wrong reasons. – relationships must be chosen wisely. it’s better to be alone than to be in bad company. there’s no need to rush. if something is meant to be, it will happen – in the right time, with the right person, and for the best reason. fall in love when you’re ready, not when you’re lonely.
- stop rejecting new relationships just because old ones didn’t work. – in life you’ll realize that there is a purpose for everyone you meet. some will test you, some will use you and some will teach you. but most importantly, some will bring out the best in you.
- stop trying to compete against everyone else. – don’t worry about what others doing better than you. concentrate on beating your own records every day. success is a battle between YOU and YOURSELF only.
- stop being jealous of others. – jealousy is the art of counting someone else’s blessings instead of your own. ask yourself this: “what’s something i have that everyone wants?”
- stop complaining and feeling sorry for yourself. – life’s curveballs are thrown for a reason – to shift your path in a direction that is meant for you. you may not see or understand everything the moment it happens, and it may be tough. but reflect back on those negative curveballs thrown at you in the past. you’ll often see that eventually they led you to a better place, person, state of mind, or situation. so smile! let everyone know that today you are a lot stronger than you were yesterday, and you will be.
- stop holding grudges. – don’t live your life with hate in your heart. you will end up hurting yourself more than the people you hate. forgiveness is not saying, “what you did to me is okay.” it is saying, “i’m not going to let what you did to me ruin my happiness forever.” forgiveness is the answer… let go, find peace, liberate yourself! and remember, forgiveness is not just for other people, it’s for you too. if you must, forgive yourself, move on and try to do better next time.
- stop letting others bring you down to their level. – refuse to lower your standards to accommodate those who refuse to raise theirs.
- stop wasting time explaining yourself to others. – your friends don’t need it and your enemies won’t believe it anyway. just do what you know in your heart is right.
- stop doing the same things over and over without taking a break. – the time to take a deep breath is when you don’t have time for it. if you keep doing what you’re doing, you’ll keep getting what you’re getting. sometimes you need to distance yourself to see things clearly.
- stop overlooking the beauty of small moments. – enjoy the little things, because one day you may look back and discover they were the big things. the best portion of your life will be the small, nameless moments you spend smiling with someone who matters to you.
- stop trying to make things perfect. – the real world doesn’t reward perfectionists, it rewards people who get things done.
- stop following the path of least resistance. – life is not easy, especially when you plan on achieving something worthwhile. don’t take the easy way out. do something extraordinary.
- stop acting like everything is fine if it isn’t. – it’s okay to fall apart for a little while. you don’t always have to pretend to be strong, and there is no need to constantly prove that everything is going well. you shouldn’t be concerned with what other people are thinking either – cry if you need to – it’s healthy to shed your tears. the sooner you do, the sooner you will be able to smile again.
- stop blaming others for your troubles. – the extent to which you can achieve your dreams depends on the extent to which you take responsibility for your life. when you blame others for what you’re going through, you deny responsibility – you give others power over that part of your life.
- stop trying to be everything to everyone. – doing so is impossible, and trying will only burn you out. but making one person smile CAN change the world. maybe not the whole world, but their world. so narrow your focus.
- stop worrying so much. – worry will not strip tomorrow of its burdens, it will strip today of its joy. one way to check if something is worth mulling over is to ask yourself this question: “will this matter in one year’s time? three years? five years?” if not, then it’s not worth worrying about.
- stop focusing on what you don’t want to happen. – focus on what you do want to happen. positive thinking is at the forefront of every great success story. if you awake every morning with the thought that something wonderful will happen in your life today, and you pay close attention, you’ll often find that you’re right.
- stop being ungrateful. – no matter how good or bad you have it, wake up each day thankful for your life. someone somewhere else is desperately fighting for theirs. instead of thinking about what you’re missing, try thinking about what you have that everyone else is missing.
Sad but kind of true, or maybe it’s just the cultural difference..?.. not sure..I mean sometimes I think those characters are pretty pathetic, really, like how they always try to prove that they are having a great time, or how they enjoy their lives, how they love being a Hong Konger in an international metropolis, blah blah blah, but all i see is that they are just ordinary people trying to make a living out of whatever they do, and most of the time they hate it, they couldnt stand it, and they wish soooo much that things can change…..anyway…wtf should i care….
Well, what’s more pathetic is that I seriously read through the whole article and is reposting it to my own blog even i know it’s more like a try-to-cheer-you-up kinda joke-like post after i scanned through the first line…………..==!
The writer ironically elaborates ten things that most of the Hong Kong people would do that make them stand out from the tourists, e.g.: walk extremely in a rush manner as if they are in a speed walking compitition ; take tons of photos in the restaurant and post’em all to FB pretending they had a very good time even the food sucks and they could barely stand it; and also how they abbreviate everything trying to make it easier and save some time, but turns out to make everything more weird, like they way they say ‘sor ar’…simply annoying..><
If there’s anything else that i can add to the list, wearing brand products is definitely on it, LV bags, channel glasses, oh.. iphone is a must-have item, or else how can u possible stay on the metro for nearly an hour…==! lmao
Other than that, i think this writer reallllllly did a great job in summarizing the key weird characters of hong kong local people….LOL..enjoy..
How to be a Hong Kong local: 10 tips on faking it
Stop sticking out like a teetotaler in Wanchai and try out these little tricks for blending in with the locals in Hong Kong.
Have a tip for pretending to be a Hong Kong local? Share it in the comments box below.
Also on CNNGo: The dirty-fun guide to Hong Kong’s Wanchai bars
1. How to hail a cross-harbor cab
To get a cab that is willing to cross the harbor, you could do the obvious and look for one of the rare signs for a cross-harbor taxi stand.
Or you could just randomly flag down cabs and have an awkward shouting negotiation through the car window with the driver who will be seated on the far side of the car.
Or use the cross-harbor arm wave.
Extend one arm in front of on-coming cab, use the hand and wrist to make an ocean wave motion, indicating that you want the cab to metaphorically brave the harbor waters.
Yes, we know that cabs are legally obliged to take you wherever you want to go. A true Hong Konger knows that laws should be interpreted only as loose guidelines. See the recent chief executive (and election) dramas for further details.
2. How to speak
End every sentence, in English or any other language, with a Cantonese final particle, such as: la, ar, wor, gar.
For example: “Hong Kong is so awesome la!”
Find out more about Cantonese final particles on www.cantonese.sheik.co.uk.
3. How to use an umbrella
The importance of the umbrella to Hong Kongers can’t be overestimated. Rarely exalted, often abused, regularly left at a bar or in a car, the underdog tool is a Hong Konger’s best friend, come rain or shine.
People, particularly women, always have a little retractable umbrella on them that also has an anti-UV coating.
The umbrella keeps them relatively dry during downpours. For a city that gets rain for six months of a year, its denizens really don’t like to get wet.
The other half of the year is usually hot with strong sunshine and the magical shield is pulled out again to block sunrays and keep the skin Fancl white.
4. How to document life
S**t Hong Kong people say at restaurants: “Oh this dessert looks so cute! Hold on, can you take a photo of me and this dessert? Do one more with the flash off. I blinked, take another one.”
Next thing you know, eight sets of photos with the same dessert but a variation of faces are uploaded to Facebook while the cake collects dust.
Nothing in Hong Kong is more satisfying than flooding friends with photos of our food. It can be more satisfying than eating the food itself.
So always ask if anyone wants to take a photo before setting your chopsticks into something.
Also on CNNGo: Staying in the rural home of a Hong Kong eco-cook
5. How to ask for tissues
Asking for Kleenex will get you nowhere. We know the little sheets of delicate paper for wiping fingers and noses as “tissue” (pronounced “T-see-u”) or Tempo, the dominating brand in Hong Kong.
Most self-respecting Hong Kongers always have a wad of Tempo at the ready, partly because newspapers and magazines come with a complimentary pack. Sometimes, promo folks hand them out at MTR exits just to make sure you aren’t without.
6. How to tip
Show your servers how much of a local you are and be stingy with tipping, or don’t tip at all.
A service charge is almost always included in the bill, so Hong Kong diners don’t bother tipping unless the waiter did something extraordinary such as deboning your sweet and sour pork.
Tipping is more about getting rid of loose change really. So people will leave HK$5.50 for a $500 meal.
7. How to order food
Hong Kongers are very specific (picky) about what they want to order. The customized meal orders at a local diner rivals Starbucks coffee orders.
The most commonly heard orders are “iced lemon tea with less sweetness no ice and lemon slices on the side” as well as “fish ball noodles with no greens plus beef brisket soup base.”
There’s no chef snootiness to put up with here.
8. How to abbreviate
One thing Hong Kongers have in common with Aussies — we like to abbreviate.
It’s either because we are extremely lazy or extremely industrious — we can’t be bothered to say the full phrase or we need to fit in as many nouns as possible in a short amount of time. Either way, we like it low on syllables.
The 7-Eleven convenience store is just “Seven” (pronounced “seh-fun”), Circle K is “OK” and the spam and egg sandwich is literally “sp-egg-wich” in Cantonese.
Our favorite is saying “sorry” — rendered as, simply, “sor.”
9. How to not hold up the line
When it comes to commuting, it is all about not stopping. The body must be constantly moving foward.
That is why train and bus schedules are committed to memory and it is also why it’s imperative Octopus cards are always topped up and taken out ahead of time when one needs to pay.
The idea is to pass nonchalantly through the MTR turnstile without having to slow down at all.
Don’t be the slowpoke tourist who fumbles to find the Octopus card at the bottom of your bag only after you hit the turnstile.
Or worse yet, not have enough credit.
There’s nothing more blush-worthy than the haunting, high-pitched beep of a rejected Octopus and the walk of shame away from the turnstile.
10. How to count with hands
The best citizenship test as immigration officials will tell you, is to count in the local dialect. Take it up a notch and count in the local sign language.
These three numbers can really show off your local know-how: six, nine and 10.
The number six can be represented by holding up six fingers. If you’re a gauche tourist.
Hong Kongers like to do it elegantly and use the “hang ten” hand sign to symbolize six.
Nine gets a graphic representation, by curling the index finger down to resemble the shape of the number “9.”
And to sweep your fruit vendor off her feet, make a cross with your index fingers to indicate that it is exactly 10 apples you want. The international sign for warding off vampires is the Hong Kong sign for the number preceding eleven.