+ Reply to Thread
Results 1 to 1 of 1

'Simple Gantt' - Small, feature rich gantt chart requiring minimal formatting - finally!

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    'Simple Gantt' - Small, feature rich gantt chart requiring minimal formatting - finally!

    Hey all,

    I'd like to submit an idea for July's competition. I posted already here: http://www.excelforum.com/tips-and-t...g-finally.html

    so I'm just going to leave that post below and preface it with this. (Hope that's OK).

    In short, couldn't find a feature rich, nicely designed excel based spreadsheet online that didn't cost me $79.99 or whatever. So I built one myself.

    Less of a 'tip' and more of a tool. Although the tip could be 'how to create an excel based Gantt chart'.

    Check it out.

    -------------ORIGINAL POST FOLLOWS--------------------------------------------------

    Update 1: Updated with new version. Some cool new tools. Added a key-features guide also. Both links attached.

    Hey all,

    My first post and contribution to the forum.

    Mini background story: Looking for an excel gantt chart that mimicked the best of MS project without the size, cost, lack of portability and bell and whistles I could do without led me to many solutions but none really made the cut. Some lacked basic features, other were too high maintenance, others just looked ugly -we're still talking about gantt charts here - So, I built one myself.

    So what's it?: 'Simple gantt'. A easy to use, feature rich gantt with some clever functionalities. Everything should work out of the box, so no messing with formulas and dates and all that stuff that makes some existing excel based gantt charts, frankly, really annoying.

    There's a how to guide/key features inside the tool, but I'll list my favourite here:

    The date bars update automatically. THIS is what every excel based gantt should do. If I have to manually update the date bars everytime my date changes (In a big project, that could be a lot!) that would get ridiculous. Now you don't have to.
    Choose the colours of the date bars from a drop down. The current options are blue, green and orange. - Again this is taking something manual and making it automatic.
    Get a Task summary via comments anywhere along date bars. Clicking on any bar in the barchart area creates a comment. In this comment you can see all the key information related to that particular task - including number of days since project began/until project starts. So even if you're scrolling across the barcharts, you have key information at a click. A very cool and quick way to get the key details for a task.
    Some clever conditional formatting to highlight weekends, current day, the current task etc.

    That's a brief summary, open it up to see it in action and the rest of the features. It's set up with a dummy project to show how it looks. Make sure to read the how to below the gantt.

    Check it out (attached) and let me know what you think. And be kind on the code, I'm not an excel pro but i'd love ideas on how it can be approved. Cheers.

    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by mikeem; 07-13-2012 at 06:44 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1