Excel Gantt Chart

This project was awarded to naveenvarthaan for $30 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

Good day everyone...

I have the following requirement and i hope everyone will read the description and requirements carefully and then bid. I dont want keep on explaining from scratch once i award the project to a freelancer, specially that there is no time, this should be delivered by tonight or tomorrow at MAX.


I have the attached Excel file... there is two sheets {Planning and Chart}, the chart sheet have a list of object(A,B,C..etc) names with the whole 2013 calendar next to each object

The planning sheet, will be like a source of input to draw the chart, it will have data about these objects, you will find for example Object A with Date1, Date2 and Date3 values...

The idea is that we need to read the data in planning sheet and check if it has a record in the chart sheet and then start filling the cells within the dates given to create the gantt chart


1- the list of objects in the chart sheet is not fixed! some times it will be like A,B,C,D only and some times will be more!

2- when we run to generate the chart, all previous chart should be cleared and start over as new one.

3- when reading from the planning sheet, if there are more than record for the same object {as in the sample file attached}, then chart should be filled on the same record for that object... (this means, in chart sheet we will have a list with distinct values of object names with many duration filled, but in the planning sheet we will have list with duplicate objects )

4- each object in Plaiing sheet have 3 dates values (date1,date2 and date3)... when we fill these dates in the chart sheet... we need to fill the period from date1 to date2 with color BLUE and the period from date2 to date3 with color RED

Hope the whole idea is clear now... Good luck

* Please remember, this is to be delivered either today late night or tomorrow by midday! bidder with 3 days+ delivery.. thank you,

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online