Advertising

Advanced Gantt Charts in Spreadsheet

Advanced Gantt Charts in Spreadsheet
Advertising

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 Lifehack Reviews: 50 Best Life Hacks for Your Life 2 Best Life Hack Sites – 100 Most Useful Websites on The Internet 3 80 How-To Sites Worth Bookmarking 4 20 Unusual Uses for Coca-Cola That You’ve Never Considered 5 A Review of the Book “The Art of Learning”

    Read Next

    Advertising
    Advertising

    Last Updated on July 12, 2021

    Lifehack Reviews: 50 Best Life Hacks for Your Life

    Lifehack Reviews: 50 Best Life Hacks for Your Life
    Advertising

    Do you want to be as productive as many of us, but missed a lot of actions at lifehack.org during the year? We’ve selected the best 50 life hacks, based on their popularity and contents in different categories. Invest your time – read them. Bookmark this page and mark reading them as one of your new year resolutions.

    Communication, Writing, Studying

    1. My Best Presentation Tricks
    2. The Business Card Game
    3. Persuasive Writing for Students, Webmasters, Bloggers, and Everyone Else
    4. 7 tips of handling your Emails without feeling overwhelmed
    5. Writing as a Form of Self Healing
    6. Advice for students: Writing by hand
    7. Yes, But Do People Like You?
    8. Writing – Just do it!
    9. A good place to study
    10. Blog your way through Writer’s Block
    11. 14 Tips for Communicating Ideas

    Productivity, Creativity, Motivation

    1. 9 Top Secrets of Naturally Born Organizers
    2. Fight The Flab!
    3. More Fight The Flab!
    4. Limit Creativity, Get Innovation
    5. Precious Moments
    6. 5 Ways to Improve Your Productivity in the Office
    7. A Geek’s Best Lifehack
    8. What Kind of Paranoid Are You?
    9. Being A Creative
    10. There’s No Time!
    11. The Mysteries Behind Motivation and How To Manipulate Them
    12. Time Management: Handling Disruptions in Daily Schedules
    13. Productivity Hack: Write Mini Process Flows
    14. Design an Online Workflow

    Management, Self-Management, Entrepreneurship

    1. Bare Bones Project Hacks
    2. The 10 Beliefs of Great Managers
    3. The Simplest Path to Success
    4. Letting Things Go
    5. Closet Entrepreneur
    6. Time To Discard The Portmanteau
    7. 5 Important Keys to Bootstrap Your Entrepreneurship
    8. The Most Underutilized Tool for Effective Communication
    9. Everyday Performance Reviews
    10. Meetings, @&!!$*@ Meetings!
    11. What Are You Worried About?
    12. How to Ruin Your Career In Five Easy Steps

    Procrastination, Goal Settings, Life

    1. 9 Steps to Define your Goal Destination and Devise a Plan to Get There
    2. Pro-Active Steps to Prevent Procrastination
    3. Improve Your Life By Following A Schedule
    4. The Causes of Procrastination And How To Conquer Them
    5. How To Make Resolutions You’ll Keep
    6. Literal Life Hack: Cut your window of time in half
    7. New Year’s Resolutions and Deficit Thinking
    8. 6 Sleep Tips
    9. Risks versus Rewards Worksheet
    10. 5 Tips for Getting Out of Debt (and Why)
    11. Deep Breathing: A Great Health Trick
    12. 8 Expenses to Cut and How
    13. Desk-side Fitness

    Are there any lifehacks that you’ve learned over the past year?

    Advertising

    Featured photo credit: Rainier Ridao via unsplash.com

    Advertising

    Advertising

    Read Next