Little bit of Excel help please.
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
I think you can plot both hours and percent if you use the "line on 2 axes" chart option in excel.
Thanks John. I am doing the same thing you described. I was just being a little lazy and trying to come up with an "automatic" solution!!
Hi Keith,
I dont think you will be able to get excel to plot both hours and percentages on the same chart.
What I have tried to do over my planing years is to work in the unit of manhour /cost, with percentages being just an add on table to give an indication of the progress.I have found this is easy to understand from a managemnt point of view.
I always start with the "original manhours curve", this being what was "seen" at the start of the project.This curve will never changes and will remains unchanged through out the duration of the project.
When addition manhours of scope is added or even deducted I use a second curve called the "current manhour curve" which reflects the changes.
Against the original & current curves I then add the "actual curve" etc.
If the management need percentages I just set up the excel table and use the data from the curves to generate the percentage.
I have a few pdf examples lying about if you like to contact me, I could email over to you
Regards
John L.