Plotting a finish date based on performance

[Butch Manchester]

Hi, I'm an excel novice and as the years pass and the selections of formulas increase I get lost and end up plotting quantum physic type solutions for what appear to be the simplest of exercises.

Here's what has been driving me insane (even YouTube couldn't help !).

I have a volume of work 1600 items. Each week I process some or none of these items I.e. 20, 34, 0, 22 over a 4 week period. I need to show a plot burn down line (based on each weeks performance) of a predicted finish week. Obviously, this would continue to change based on each weeks output.

This is easy to do on paper but I can't translate this into Excel 2010). I'd be grateful for your help

[jd16]

Hi, I'm an excel novice and as the years pass and the selections of formulas increase I get lost and end up plotting quantum physic type solutions for what appear to be the simplest of exercises.

Here's what has been driving me insane (even YouTube couldn't help !).

I have a volume of work 1600 items. Each week I process some or none of these items I.e. 20, 34, 0, 22 over a 4 week period. I need to show a plot burn down line (based on each weeks performance) of a predicted finish week. Obviously, this would continue to change based on each weeks output.

This is easy to do on paper but I can't translate this into Excel 2010). I'd be grateful for your help

IS this you want ??






Regards
---------------------------------------------


Don't forget to Click * Button if you got the solution or any idea because of this post, and if you got the solution, don't forget to go to Thread Tools & mark your thread as solved

[Butch Manchester]

Not really, I've enclosed a picture of the line graph I'm trying to achieve. I hope this makes things a little clearer? Tx

Plot.jpg