skip to Main Content

Excel Gantt Chart Maker

Rated 4.70 out of 5 based on 10 customer ratings
4.7 (10 reviews)

Excel Gantt Chart spreadsheet template lets you create your Gantt chart with just a button click! All in Excel, no installation needed. Works on Windows and Mac.

$39.95

(One-time Payment | Instant Download)
BUY NOW

Payments are processed by our partner company Paddle.com.
You will receive a download link immediately after purchase.

TEMPLATE DETAILS

License: Personal Use
Works on: Windows / Mac
Requirements: Min. Excel 2007
Bonus: Free Lifetime Updates with your purchase.

PRODUCT DESCRIPTION

Gantt charts are one of the most popular project management tools in business life. Even though this methodology is almost older than a century, they are still widely used today. For this reason there are lots of Gantt chart software options on the market nowadays. Why should you choose the Someka Excel Gantt Chart Maker template?

One of the main reasons is that, it is all in Excel! All of us already use Excel in our day-to-day business operations. Then, why would you go to another tool, take your data from spreadsheets, put into it, take back etc. when you can do all of these in a single Excel template? (If you have ever used MS Project or any other similar Gantt chart software, you will know how tedious these tools are) Besides, these tools have steep learning curves – they take a really long time to get used to the interface and features. We all know these problems, experienced it ourselves and that’s why we have built this Excel Gantt Chart Maker:

Excel-Gantt-Chart-Maker-Someka-Gif-Opt

No new software, no installation, nothing to learn. Everything in Excel. Just open this Excel Gantt Chart Maker and start building your project’s Gantt chart!

Someka Excel Gantt Chart Maker is quite user friendly and easy to use. At the same time, it has powerful features in the background, which lets the user to do lots of different things if needed. Let’s check what can you do with this Gantt Chart Maker Spreadsheet.

 Check the VIDEO below to see how Excel Gantt Chart Maker works:

Excel Gantt Chart Maker - Someka Excel Template Video

PROJECT TASKS and DATE MANAGEMENT

Easy to input Tasks/Sub-Tasks: This is one of the most challenging issues in project management. In our Gantt Chart template, we’ve used a well-known method called WBS (Work Breakdown Structure) You can either choose from dropdowns, write them manually or simply copy and paste from an existing spreadsheet.

Excel Gantt Chart Maker - WBS Structure - Someka SS1

Easy Sorting: You have already created your tasks but later on you notice that you have to add a subtask to an existing task. You don’t need to deal with deleting/inserting rows. You are free to input the tasks in any order you like. Just click the “Sort Table” button and it will automatically sort your tasks according to the WBS numbers.

Auto Sub-Totals: Sometimes we create many sub-tasks and want the duration of the main task to be calculated automatically by summing up its subs. This feature handles all the hassle. And it is optional. You can turn it off and create your Gantt chart with full freedom.

Categories and Automatic Coloring: You can use categories in both grouping your tasks and painting them. If you wish, you can define different colors for each of your categories and have them painted automatically in the Gantt chart.

Excel Gantt Chart Maker - Automatic Coloring - Someka SS2

Duration Days and Force Start-End Dates: In the simplest way, you can use the tool by inputting days for each task. But if you want some specific tasks to start or end on certain dates, the tool also allows the user to input manual start/end dates. If any manual date is inputted, background calculations follow this information.

Bold Tasks and Indent Sub-Tasks: You have lots of main tasks and sub-tasks, and want to make the main tasks bold for easier reading? You don’t need to deal with formatting, this feature does it automatically. It also indents the subtasks according to the WBS numbers.

Progress: This is an optional feature. If you want to see what percent completed any task is, you can use this column.

GANTT CHART REPORT and VIEW OPTIONS

Daily/Weekly/Monthly View: This selector lets you choose a report view from 3 different options. Besides, you can even choose how you want to show Day Initials (First letter, First 2 letters or hide)

Report Depth Feature: This is quite cool for project managers. You can choose to see the report based on main tasks only. This lets you to see the “big picture” of the project. Or you can select to see the deepest details. This is handy for micro-management of sub-tasks.

Excel Gantt Chart Maker - Report Depth View - Someka SS3

Holidays and Off-Days: Not every project stops at weekends. It all depends on your business nature and Someka Gantt Chart Maker also lets you to customize this. You can choose which days of the week are off-days. Also you can define national holidays or other specific dates on which project will be on hold. All calculations in the background will be made considering your inputs and selections. The template will skip holidays while calculating task durations to let you make the most correct project time planning.

Excel Gantt Chart Maker - Holidays Input - Someka SS4

Show / Hide Holidays: Above we have mentioned how flexible the tool is for holidays and off-days. In addition to that, you can show or hide holidays on your Gantt chart report. (If you decide to show, you can even paint holidays and off-days to the color you choose!)

The best part is, all of these are available in Excel, the software you are already using everyday. As mentioned already, no need to install anything. Just open and start building your Gantt chart!

EXCEL GANTT CHART MAKER FEATURES:

  • Unique product for auto generation of Gantt charts in Excel
  • Works both on Mac and Windows
  • No installation needed, ready to use.
  • User friendly and professional design
  • Export to PDF feature
  • Full Print Ready
  • White Label
  • Automatic Category Coloring
  • Task progress bars
  • Daily / Weekly / Monthly Views
  • Show / Hide Holidays
  • On Sheet Instructions and Help Section
  • Compatible with Excel 2007 and later versions

This excel template is prepared with VBA macros. Don’t forget to enable macros after you get it. If you need customization on your charts or more complex schemes, just contact us via [email protected]

USER REVIEWS

10 reviews for Excel Gantt Chart Maker

  1. Rated 4 out of 5

    Nadya

    Recently, I purchased the someka gantt chart template, Generally, I like the template,
    But when I put my own project which is only 23 rows, unfortunately, the file size became 30.000 kb.
    so i cant send it to other 🙁 It creates me another separate work using sendspace etc . Help me

    • Someka

      Hello Nadya. File size gets larger if you choose to display very long time frames with small steps (eg. displaying a 10-year project with daily details)
      We have sent you an email with shrinked version for your specific case. Hope this helps!

    • Nadya

      Thnk you so much the Someka experts.
      The size is really much reduced. Awesome 🙂
      My original work plan has 3 components. The file i sent you is components-1,
      So i put another 2 components luckily the size is still OK around 9800

  2. Rated 4 out of 5

    pjbtran

    Everthing is ok but pls add more column!!!

  3. Rated 5 out of 5

    Latonia S.

    nice template which I can use with my Mac. Since I can not use Microsoft Project on my Mac this was very helpful.

  4. Rated 5 out of 5

    Kath Mitchell

    Lifesaver for my job. Very easy to work with. Thanks Someka!

  5. Rated 4 out of 5

    Yurena Montserrat

    You don’t have an Spanish version of the product!!

    • Someka

      Hi Yurena! With the purchase you get the passwords and modification rights for the templates. So you can modify lines to add the Spanish descriptions!

  6. Rated 5 out of 5

    Mohamed

    Simple and reliable!

  7. Rated 5 out of 5

    Shetye

    Simple and Effective template which I was looking for..Off course team is cooperative and efficient. Thanks.

  8. Rated 5 out of 5

    zakariya3292

    Professional with a good price, Thanks,

  9. Rated 5 out of 5

    Shak.

    Exactly what I needed and super quick delivery!

  10. Rated 5 out of 5

    Dumichauch

    Great tool for a very good price. Highly recommended!

Add a review

Your email address will not be published. Required fields are marked *