I am trying to create a progress chart, sort of like a burn up chart with reference to weighted milestones.
I have a table with columns including; finish date, percentage complete of the milestones, the weighting of each milestones (weighting), The Calculated Value (Actual), Value of the Project Milestone (As a percentage of the entire project) and a running total of the milestones value (%).
I was hoping to find actual versus planned in this respect but just a tracking of time versus % would be ideal. I created a reference Calendar to try help the process with dates but the more I play the more I am finding myself lost.
Where am I going wrong and what is the better approach to go about it?