jamie said:
i want to add up numbers in the graph side of the page. eg. 5 projects which
have 5 employees working on each, the number to appear on the line of the
project length. i want to show it as follows...
5
5
5
5
5
25
can this be done? or this an excel job?
thanks
jamie,
I guess I'm not clear on what you mean by the "graph" side of the page.
I guess I could assume you mean the graphic for the Gantt Chart (i.e.
Gantt bars). It is also not clear what you mean by, ". . .appear on the
line of the project length.".
Assuming you are referring to the Gantt graphic, Project does not have
the flexibility to add columns of data to the right of the Gantt
graphic. The best you can do is to set up a custom field on the far
right of the tabular Gantt data (left side of Gantt Chart view) and put
the summed values in that field. And off hand, I can't think of any
formula that could be used in the custom field to sum up the number of
resources assigned to each task, however, VBA could be used for that.
Depending on what you are trying to display (i.e. number of projects,
number of employees), it may in fact be easier to either copy or export
the necessary data to Excel and set up the desired formatted Worksheet.
Hope this helps.
John
Project MVP
