98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Project Training and help » Tracking
Tracking
Resolved · High Priority · Version 2003
Tue 17 Mar 2009, 16:15Delegate Patrick said...
Patrick has attended:
Project Intro Intermediate course
Tracking
Is it possible to track multiple costs (as they happen) along the bar in the gantt Chart? So as you spend, it updates along the bar?
Thu 19 Mar 2009, 09:53Trainer Stephen said...
RE: Tracking
Hi Patrick
Thank you for your question
Could you clarify a few points for me please. By multiple costs do you mean different costs such as traveling expenses, Stationary etc.? Also do you want all the costs to appear on the bar, or just a total figure?
Thanks
Stephen
Thu 19 Mar 2009, 10:10Delegate Patrick said...
RE: Tracking
Hi Stephen,
Yes different costs, and as they are spent/inserted into the cost columns, they update along the bar in the gantt chart like a progress line, but instead of a progress line it is split up so it looks like a "rolled up bar".
Yes, I want to cost as they are spent shoing on the bar, and have the total figure at the far right of the bar.
I realise that you can insert figures, on, top, bottom, left and right of the bar.
Im sorry and I know this is complicated, but if you could help it would be sensational.
I want to know is it possible to do this?
Thanks
Pat
Wed 22 Apr 2009, 13:59Trainer Andrew said...
RE: Tracking
Hi Pat
Thank you for your question. The way progress is shown on the Gantt chart is controlled by the Format > Bar Styles dialog box.
You will see that the fields available to you in the From and To columns do not include cost fields. Without them I don't think it would be possible to show spend as a bar drawn through the task. Unfortunately limitations on the way the shapes are drawn mean there is no way that I can see to produce a multi-colour rolled up style progress bar within a task.
You may get more value by exporting your data into Excel and visualising it there. Choose File > Save As and set the output type to Excel Workbook and follow the Wizard.
I'm sorry we couldn't be of more help this time. Do let us know if you have any further questions.
Kind regards,
Andrew
Tue 12 May 2009, 15:11Delegate David said...
RE: Tracking
Hello Pat
Have just been viewed your query
Am I correct in assuming you just need Prorated figures of Costs incurred throughout the project timespan?
If so, by updating the '% Completed' at regular 'Status Date' Intervals, you should find using the 'View' toolbar drop down Menu useful.
Clicking on 'Table:Entry' will then show you a series of options Project is able to Illustrate to you.
If you click on 'Cost', the Gantt view will change to show you Actual and Prorated Costs and Variances from your Project's Baseline Start.
This information is availible by using Microsoft's Step by Step Manual, Section 18- Measuring Performance with Earned Value Analysis.
It's not what I would call bedtime reading, but its a very useful tool for a complex programme like Project.
Hope it points you in the right direction -
Good Luck
David
Wed 27 May 2009, 10:12Trainer Andrew said...
RE: Tracking
Hi David - thank you for your suggestions too.
Kind regards,
Andrew
Tue 2 Jun 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Using the Quick Access Toolbar in Project 2010The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
