Microsoft Project: Using Graphical Indicators

Sir Ganttalot explains that getting the "big picture" on a project can be difficult if you have to interpret hundreds of tasks one by one to find out which ones are good in terms of progress and baseline variance, and which ones are not. Adding Graphical Indicators to a Gantt Chart can help you zero in tasks which are going well, or going badly. In this video Sir Ganttalot explains what Graphical Indicators are, and how to create them and use them in your project schedules. Sir Ganttalot is sponsored by Westall Murray International, Inc. www.WestallMurray.com

Category:

Education

Tags:

• Microsoft
• Project
• MS
• Graphical
• Indicators
• Dashboard
• Sir
• Ganttalot
• SirGanttalot

[cparedes08]

Thanks for the video, very simple but never knew about it. I will apply it right to my current project on monday

[SirGanttalot]

Thanks for the feedback. I'm glad the information is of real, practical help to you.

[azamora2005]

cool video... It would be interesting to listen your perspective about Critical Chain Management.

Thanks for the great job!

looking forward for your next video.

[SirGanttalot]

Thanks! People who like the Critical Chain approach find it VERY helpful. It is best used when availability of resources is a serious constraint. A critical path is calculated without taking resources into account, resource constraints are then factored in, a new CP is calculated, and duration "buffers" are calculated. The PM then focuses on managing buffers and managing resources. MS Project does not support CC directly, but some CC products do interface with MSP. Give it a whirl!

[graspman]

@SirGanttalot

Actually I mentioned the wrong formula. In my previous post I asked for just the formula to % complete variance. I meant to also ask for the more complicated formula for Baseline Variance. Much appreciated!

[SirGanttalot]

Hi, I just sent you a message on this issue. Let me know if this helps.

[gorefish]

Can you post the formula you used for the %complete variance column? Thank you!

[patxipiratak]

Thans I think is a good video to undestand the graphics symbols and some formules.

I would like know if the are another video about how create formules .

Sinceraly form Basque Country

[Violetster]

Excellent, superb, BRAVO! Thanks for the tips!

[MrBabylonlion]

if i have 5 elements or sub tasks in my project the 1st 1000 hrs , 2nd 3000 hrs , 3rd 5000 , 4th 500 hrs . 5th 500 hrs , What is the overall % Complete with decimal if the % work Complete for the 1st task 100% , 2nd 49 % , 3rd 88% , 4th 90 % ???? I want the overall % Complete depending on the work complete for each task with decimal , can I have your E.Mail ?? thank u very much.

[graspman]

@SirGanttalot

thank you for this video. I also see immediate practical use. One question, do you have the formula posted anywhere for the % complete Variance? I followed along with you step by step and am just missing the formula to immediatly integrate into my current project plan.

[Amberlina03]

Thank you so much for your videos, they're helping me a lot! Do you happen to know if there is a way to insert an image into Project, similar to how you can insert an image in an Excel cell? (I have MS Project 2010 Standard.)