Project Tracker with Graphs in MS Excel

In Progress Posted Feb 22, 2013 Paid on delivery
In Progress Paid on delivery

I need a spreadsheet where I can track my projects' phases progress.

The spreadsheet has to record overall planned start and end date for a project AND the actual start of a phase within the project and the percent complete.

The spreadsheet is described in detail in the file attached.

colors for phases have to be configurable

collapase functionality has to be there

must be able to track at least 40 projects

I must be able to print the whole spreadhseet (projects summary+ graphs) in one 8 by 11 letter in landscape.

The project summary line must display 1|) graph bar representing planned start and end dates and 2) each phase graph bar, successively, all in one line. both graphs must be displayed in the project summary line so when I collapse a project, i can see how my phases are traking against my overall planned dates for the project.

It is very important to have a bar chart graphing overall planned start and end dates and multiple bars tracking each phase of the project from actual date and progress (progress=duration * completion). at the project summary row.

If it cant be done in excel, im open to other options... but must be the same layout as in the spreadsheet atatched and easy to use on/off line.

I NEED THIS BY SUNDAY. LEMME KNOW FEASIBILITY. THX.

Data Processing Excel Microsoft Project Scheduling Windows Desktop

Project ID: #4271847

About the project

3 proposals Remote project Active Feb 22, 2013

3 freelancers are bidding on average $88 for this job

vickkey7

I am ready to start this project. thanks

$170 CAD in 2 days
(7 Reviews)
3.1
hdananjalee1991d

PLZ GIVE YOUR Project

$50 CAD in 2 days
(0 Reviews)
0.0
nawazwasif

Respectable, My name is Muhammad Nawaz. I have spent 15 years of experience in IT field. But on Freelancer.com it will be my 11th project. My services are in internet campaigning, managing emails, contacts, research More

$45 CAD in 10 days
(0 Reviews)
0.0