I don't think this can be done within Excel, but then again, some of you have
some very creative ways of getting things done!

I have a client who would like to create a stacked column chart. Here is
some sample data.

Day 1 Day 2 Day 3
ab 6:00:00 AM 6:00:00 AM
cd 6:30:00 AM 2:50:00 PM
ef 9:15:00 AM 6:00:00 AM
gh 1:30:00 PM
hi 4:00:00 PM 6:45:00 AM 1:00:00 PM

The chart would have the Days along the X axis and the times along the Y.
Each day goes from 6:00 am - 6:00 pm.
On Day 1, Product ab is run from 6:00-6:30, Then cd from 6:30-9:15, etc.
Not all products are run on all days. Some days may have 10 products and
others only have 2.
He would like the chart to show the duration of each run but also indicate
the time span. The problem is, the products don't necessarily run in the same
order. Notice Day 2 data. A stacked column chart has no problem displaying
the duration of each run, but can't show the actual time span. He likes the
look of the stacked column - is there a different type of chart that could be
used?

Thank you!!

--
maryj