Project Tracker with Graphs in MS Excel or Access - repost

I need a spreadsheet/db 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.

I am open to excel, ms access, im open to other options too... but must be the same layout as in the spreadsheet attached and very easy to create new projects and update existing ones. usability is definitely a major aspect.

Again, the layout has to be exactly as in the spreadsheet attached.


Taidot: tietojenkäsittely

Näytä lisää: project tracking excel graph, multiple project tracker excel, update tracker, representing graphs, representing data in graphs, how to graphs, how to graph data, how to create graph, how to create a graph, graphs with data, graphs of data, graphs in c, graphs for data, graphs data, graphs c, graphing of data, graphing in c, graphing data, graphing and data, graph graphs, data in graphs, data graphs, data graphing, data for graphs, data for graphing

Tietoa työnantajasta:
( 5 arvostelua ) montreal, Canada

Projektin tunnus: #4273669

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, I can do this for you.

$75 CAD 2 päivässä
(1 arvostelu)

Please share the project

$250 CAD 2 päivässä
(0 arvostelua)

Hi, Ready to work upon this. Regards,

$200 CAD 2 päivässä
(0 arvostelua)

I am in a position to that work for you

$150 CAD 1 päivässä
(0 arvostelua)