Excel Gantt Chart

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,

Evner: Excel

Se mere: gantt chart excel, excel gantt chart, want to create a chart, sample thank you notes, night-fill, night fill, freelancer with excel, freelancer red, freelancer planning, freelancer notes, freelancer in excel sheets, freelancer excel like, freelancer duplicate project, freelancer calendar, find a freelancer today, delivery record sheet, calendar freelancer, gantt project, freelancer draw, reading notes, gantt, freelancer excel sheet, excel duplicate, excel 2013, excelchart

Om arbejdsgiveren:
( 16 bedømmelser ) Doha, Qatar

Projekt ID: #4116649

Tildelt til:


Hi adel980, I am working on this. Will deliver the file in few hours Best Regards, Naveen

$30 USD på 1 dag
(13 bedømmelser)

9 freelancere byder i gennemsnit $101 på dette job


Then you shall have it tonight or max tomorrow. Let's discuss on pmb

$150 USD in 3 dage
(64 bedømmelser)

I ready for this project. thanks

$40 USD på 1 dag
(7 bedømmelser)

Hello, I'm experienced analyst with a lot of Excel automation and macro creation. Working with large data sets is no problem for me. You can check my ratings here and see that I have successfully done even more comp Flere

$200 USD på 1 dag
(5 bedømmelser)

i can help you so faster, i am industrial engineer, and i know about GANTT, only need all detail and data like your attached sample. check Pm

$120 USD in 4 dage
(0 bedømmelser)

pleas check your Pm

$170 USD in 4 dage
(0 bedømmelser)

Hi, I am independent freelancer from India.

$45 USD in 2 dage
(0 bedømmelser)

Hi, I'm well versed with Excel automation and Macro definition. The work will be completed with utter accuracy. Lets start this..

$50 USD in 2 dage
(0 bedømmelser)

try me in this work

$100 USD på 1 dag
(0 bedømmelser)