Hi Guys, I'm a newbie so please speak slowly!
I have a project which I have been creating 3 Gantt charts in an Excel work book for. The charts are quite simple ie. tasks verses planned time and also showing progress bars for each task.
I am now putting together a Dashboard where I am copying across the charts and doing some eye catching formatting etc.
What I would like to do is to add a percentage complete figure for each of the 3 Gantt charts (across each charts tasks percentage complete percentages) and also a Project percentage complete across the three Gantt charts? My maths is letting me down a bit as well as syntax and formulas for completing the formulas(s) even if I could do the maths but, the only way I can see of accomplishing this is by using the AVERAGE function not? I am not sure that this is the most accurate way nor, the best way that this can be accomplished?
Any suggestions would be most gratefully welcomed?
Bookmarks