Consider a company that wants to manufacture new toys every so often.  It has three products codenamed A, B, and C respectively.  Management would like a chart illustrating when each product will be made.  The firm's production plans are:

First, using the data above, create the table below:

Note that the Duration column contains the formulas:

 Next create a bar chart (sub-type: stacked):

Finally, modify the result by setting the first (blue) series to no border and no area and adjusting the axis values (min. and max.), and other formatting changes:

Created Sept. 2, 1999 in response to a microsoft.public.excel.charting newsgroup posting.