Excel Gantt Timeline Generator

ByJorge Pereira 2020-01-052022-10-03

Tags: Excel, JP Tools & Apps, Project Management, Timeline, Tools & Tips

In my work, I need to quickly generate timelines. I have been doing it by hand in Excel adding each tasks in a line, formatting the columns and then snipping the graphic into the document I need to paste it into. If changes were need, it was not easy to do, and started the timeline again.

It is one of those things that I have been meaning to create some automation for, but never had the chance until a recent set of long flights which gave me the perfect opportunity to finally get it done.

I wanted to enter a start date and then a set of tasks with duration for each line item. I later added dependency and offset for each line.

Currently the spreadsheet is based on week increments. It would be fairly easy to modify to days, and add some formatting options, but will leave that for a future release.

The Excel uses only formulas.

No Macros, No VB or anything that may raise an eyebrow

Please let me know (via Twitter) if you have any ideas, suggestions or modifications. Feel free to use to as needed!

You can get the spreadsheet below:

[email-download-link namefield=”YES” id=”3″]

Jorge Pereira

Accomplished Information Technology services professional with over 25 years of experience performing technical pre-sales, solution selling, public speaking / presentations, consulting, project delivery and program management. Over the past few years, Jorge has focused on customers solutions in the areas of: Artificial Intelligence, Generative AI, Workforce Transformation, End-User-Computing (EUC) Lifecycle Management, Modern Device Management, and Cybersecurity.
Additionally, Jorge is also an artist known for his whimsical doodle art and captivating fantasy stories. More on his creative side here

Disclaimer: I work for Dell Technology Services as a Workforce Transformation Solutions Principal. It is my passion to help guide organizations through the current technology transition specifically as it relates to Workforce Transformation. Visit Dell Technologies site for more information. Opinions are my own and not the views of my employer.

Journey | Thoughts & Ramblings

Tools for Managing Passwords

ByJorge Pereira 2010-01-242022-10-07

This is not only about passwords, but all kinds of confidential data. There are so many important numbers, pins, passwords, challenge questions !! Where do you safely keep all of this information? Some of my friends have a little notebook (yes old school!). Others keep all this info stored in emails or in Word/Excel documents…

Tech Talk

News from TS2 in Seattle (Part I)

ByJorge Pereira 2008-02-012022-09-26

I attended a Microsoft TS2 event yesterday, and I’m currently preparing a report for my colleagues on what was announced and showcased. As I digest and remember everything from the event, I’ll post things of interest to the community here.

Reference | Tech Talk | Tips, Tools & Resources

Couldn’t make MMS 2012 conference?

ByJorge Pereira 2012-04-272022-09-26

Not to worry! Microsoft has posted all of the PowerPoint and videos at http://www.mms-2012.com/digitalmms regardless if you attended or not, you can register and browse through the sessions… Thank you Microsoft!! For those of you that want to download the content for offline viewing: Videos: Stefan Roth has created a PowerShell script that will…

Using your Desktop from your Tablet

ByJorge Pereira 2012-09-092014-09-16

You want access to your desktop from your tablet device ? I have been trying several of the available apps to remotely access my desktop from my tablet devices (I have an iPad and a Nexus 7 – Android), but the ones I have tried are usually clunky, slow, hard to setup or simply do…

Tech Talk

Theme Decisions!

ByJorge Pereira 2012-09-152022-05-27

I have spent so much time trying to figure out my new theme… I was fine with the theme I had at WordPress.com but when I moved to my own hosted instance, found out that the theme was not longer available for download.

Similar Posts