bmw said:
I would like to display both % spent and % complete indicators within a gantt
bar by task. I currently can display the % complete but find the information
would be much more useful and complete with both pieces of information.
bmw,
Gee I've never responded to an automobile before.
You can display pretty much whatever you want on the Gantt Chart.
However, when displaying information inside a Gantt bar, the bar itself
must be of sufficient length to contain the information. Otherwise all
you will have is a cluttered mess. If you want to display information,
may I suggest placing it around (above, below, right or left) the Gantt
bar. Your plan may still get very cluttered but at least the length of
the bar will have less effect.
Percent complete is a built-in Project field so that part is easy.
However depending on what you mean by "% spent", you may be able to
populate a spare text field (e.g. Text1) by concatenating % Complete and
% spent in a formula. If the definition you have for % spent is a little
more involved then you should consider populating the spare field with a
simple VBA macro. Once you have the information in the spare field, it
is simply a matter of going to Format/Barstyles and setting up the
appropriate bar text with the spare field information. Note that you can
also limit the clutter by populating the spare field for only a limited
group of tasks (e.g. performance tasks greater than a certain number of
days duration).
Hope this helps.
John
Project MVP
