Advertising
Advertising

Advanced Gantt Charts in Spreadsheet

Advanced Gantt Charts in Spreadsheet

Gantt Chart is useful. It tracks tasks start and finish dates, dependencies and resources. Unfortunately drawing gantt chart usually requires a project management software. Alternative? Peltier Technical Services shows a way of doing it in Spreadsheet (i.e. Excel):

Gantt Chart

    Gantt charts are useful tools in program management, which help to show graphically when tasks must start and finish, and which tasks are underway at any given time. Gantt charts help in scheduling of the many tasks in a program, and in identifying potential resource issues in the schedule. A simple Gantt chart is merely a floating bar chart, that is, a stacked bar chart in which the first series is formatted to be invisible. The second series of bars are stacked on the first, but these bars appear to float in the middle of the chart, because the first series is formatted to be invisible. My article Gantt Charts in Microsoft Excel in Tech Trax e-zine describes this simple approach.

    This example is more detailed, and therefore more complicated. There are two visible bars, so the floating bar can show fraction complete and fraction incomplete. In addition, two line chart series are added to show milestones for completed and not-yet-completed tasks. Excel will not allow an XY series to be added to a Bar-Line combination chart, so an additional line series is used as an anchor for a vertical line and label. Using a line chart allows us to use the versatile time scale axis of the line chart as the horizontal axis of the Gantt chart.

    I am not sure about you, but I feel this is a pretty cool way to generate gantt chart, without open up your wallet to purchase a project management application.

    Advanced Gantt Charts in Microsoft Excel – [Peltier Technical Services]

    More by this author

    Leon Ho

    Founder of Lifehack

    Book summary: A Technique for Producing Ideas 10 Ways to Extend Laptop Battery Life Bob Parsons on His 16 Rules for Survival Free note taking templates and techniques Fifty Essential Topics on Economics

    Trending in Lifehack

    1 How to Become an Early Riser and Stay Energetic 2 20 Time Management Tips to Super Boost Your Productivity 3 A Review of “The Art of Learning” 4 The Lifehack Show Episode 11: Mindfulness and the Authentic Self 5 What Everyone Is Wrong About Achieving Inbox Zero

    Read Next

    Advertising
    Advertising
    Advertising

    Last Updated on November 19, 2019

    How to Become an Early Riser and Stay Energetic

    How to Become an Early Riser and Stay Energetic

    When you become an early riser, you’ll experience a lot of benefits including feeling more energized and having more time to do what you want.

    If you’d like to become an early riser, there are some things you should know before you run off to set your oft-ignored alarm clock.

    So how to become an early riser?

    Here are five tips I’ve discovered to be most helpful in making the transition from erratic sleeper to early morning wizard:

    1. Choose to Get up Before You Go to Sleep

    You’re not very good at making decisions when you’ve just woken up. You were in the middle of a dream in which [insert celebrity crush of choice here] is serving you breakfast in bed only to be rudely awakened by the harsh tones of your alarm clock. You’re frustrated, angry, confused, and surprised. This is not the time to be making decisions about whether or not you should stay in bed! And yet, most of us leave the first decision of our day to be made in a blur of partial wakefulness.

    Advertising

    No more!

    If you want to be a consistently early riser, try making your decision to rise at a specific time before you go to sleep the night before. This frees you from making the decision in the morning when you’ve just woken up. Instead of making a decision, you have only to follow through on your decision from the night before.

    Easier said than done? Of course. But only for the first few times. Eventually, your need for raw willpower to get out of bed will diminish and you’ll be the proud parent of a new habit!

    Steve Pavlina suggests you practice getting out of bed during the day[1] to get a few of the “practice sessions” out of the way without the early morning fog in your head.

    2. Have a Plan for Your Extra Time

    Let’s say you’ve actually made it out of bed 2 hours before you normally would. Now what? What are you going to do with all this time you’ve discovered in your day?

    Advertising

    If you don’t have something planned to do with your extra time, you risk falling for the temptation of a “morning nap” that wipes out all the work you put into getting up.

    What to do? Before you go to bed, make a quick note of what you’d like to get done during your extra hours the following day. Do you have a book to write, paper to read, or garage to clean? Make a plan for your early hours and you’ll do more than protect yourself from backsliding into bed.

    You’ll get things done and those results will fuel your desire to build rising early into a habit!

    3. Make Rising Early a Social Activity

    Your internet or social media buddies just don’t have enough pull to make your new habit stick in the long term. The same cannot be said for the people you spend time with as part of your early morning routine.

    Sure, you could choose to read blogs for two hours every morning. But wouldn’t it be great to join an early breakfast club, running group, or play chess in the park at 5am?

    Advertising

    The more people you get involved in making your new habit a daily part of your life, the easier it’ll be to succeed.

    4. Don’t Use an Alarm That Makes You Angry

    If we’re all wired differently, why do we all insist on torturing ourselves with the same sort of alarm each morning?

    I spent years trying to wake up before my alarm went off so I wouldn’t have to hear it. I got pretty good, too. Then I started using a cellphone as my alarm clock and quickly realized that different ring tones irritated me less but worked just as well to wake me up. I now use the ring tone alarm as a back up for my bedside lamp plugged in to a timer.

    When the bright light doesn’t work, the cellphone picks up the slack and I wake up on time. The lesson learned? Experiment a bit and see what works best for you. Light, sound, smells, temperature, or even some contraption that dumps water on you might be more pleasant than your old alarm clock. Give something new a try!

    5. Get Your Blood Flowing Right After Waking

    If you don’t have a neighbor, you can pick fights with at 5am, you’ll have to settle with a more mundane exercise. It doesn’t take much to get your blood flowing and chase the sleep from your head.

    Advertising

    Just pick something you don’t mind doing and go through the motions until your heart rate is up. Jumping rope, push-ups, crunches, or a few minutes of yoga are typically enough to do the trick. (Just don’t do anything your doctor hasn’t approved.)

    If you live in a beautiful part of the world like me, you might want to use a bit of your early morning to go for a walk and enjoy the beauty of the world around you.

    If you have a coffee shop open within walking distance, dragging yourself out of bed for a cup of coffee to savor on your walk home as the world wakes around you is a wonderful experience. Try it!

    More to Power Up Your Day

    Featured photo credit: Nomadic Julien via unsplash.com

    Reference

    Read Next