Average within a Chart

[Zach]

Hello!
I'm working with a Gantt chart that I got from this fantastic website but am curious about a feature that I hope someone knows about, I've attached the form for reference. I want to find the percent complete of the entire project but since the project has 35 activities and I can only get an average of the first 30 because of the scroll feature. Is there a way to get all 35 activities calculated together to give a percent done without removing the function of the scroll bar?

Please let me know if this doesn't make any sense.

 

[vletm]

Who will update '% done' ... manually?
I test something and '% done'-values can see,
if there would be values to show...
Test ..

 

[Hui]

Right click on the Tabs, Unhide
Unhide the Calculations Tab
Copy row 40 Down 5 rows
Change Column B to go up to 35
You can now use the Table to base any math on

Refer to the attached file:

You should be aware that Averaging averages is not mathmatically correct, unless all tasks have an equal weighting to their proportion of the original project, which is very rare and unlikely