Little bit of Excel help please.
Forum Sponsor
Top Posters
James Williams
74 posts
Abkar Bannayan
25 posts
christiandt
0 posts
J Vaartjes
3 posts
Aidar Kurmantayev
0 posts
Noe Radovan
8 posts
GeoVe
0 posts
Johannes Vandenberg
14 posts
Soheil Barekat
4 posts
Peter Holroyd
51 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.