Therefore the markers show actual and the bars show plan. The marker
doesn't have to stop at the end of the bar. Adjust the value (or
formula), so it stops on the 13th.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ckrogers wrote:

:) The problem is when the quote is DONE before it's actually due. For
example:

Received from Cust - Feb. 10
Submitted to Estimating - Feb. 11
Due Date - Feb. 15
Done Date - Feb. 13
Submitted Date - Feb. 13

Is there some way to show that it was done early? When I use Feb. 15 as the
"Due Date", even though the duration to the next step is -1, the "Done Date"
and my diamond for "Submitted Date" end up on Feb. 15. Am I making this
harder than I have to ... should I just be making the bar from "Submitted" to
"Due" end on Feb. 13 instead of 15?

"Jon Peltier" wrote:


How could you finish the quote before starting it? Do you have a time
machine? Did you invent the flux capacitor?

I can't envision the difficulty, if all the data contain physically
meaningful durations.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ckrogers wrote:


I'm using the steps found in

http://peltiertech.com/Excel/Charts/GanttLinks.html

to chart a timeline for quoting from Received From Customer-Submitted to
Estimating-Due Date-Done Date-Submitted to Customer. I even use the
diamonds at the end for the date finally submitted to the customer to close
out the quote. It works great! My one problem is when the quote is done
early (with a negative duration), the bars don't adjust so my end date is
that many days longer than it should be. Is there any way around that?