Overlapping Time Chart?

Is there a way to graph a chart by date (x axis) that shows stacked
bars for overlapping time?

Ideally, I would have the columns like below:

Date ShoppingStart TimeShopping
StoreAsStart TimeInStoreA
StoreBStart TimeInStoreB

1/1/08 7:00AM 5 hrs
8:32AM 45 min 10:00AM 1.5 hrs

Then you would see a bar for that date, with 1 big bar for the day,
with 2 colors inside that bar representing the time in shop a and the
time in shop b. The y axis would be hours from say 6:00 AM - 7:00
PM. Does this make sense? The Time in A and Time in B could
overlap. Any thoughts would be great!

On Wed, 2 Jul 2008, in microsoft.public.excel.charting,
misscrf <misscrf@yahoo.com> said:
>Is there a way to graph a chart by date (x axis) that shows stacked
>bars for overlapping time?

Check out this earlier thread in the newsgroup and see if it helps you:

http://groups.google.co.uk/group/mi...arting/browse_t
hread/thread/7528156a909aed7b/8cbd3b109557d853?#8cbd3b109557d853

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Thank you for the response. I have looked at the gannt charts, but I
will be honest I am completely lost as to how to plot them. I am just
missing the concept completely. Can you or anyone please give me some
direction as to how to set up the chart?

Thanks!

What I mean to say, is how do I set up the spreadsheet, so that the
chart can be created? I am not understanding what columns I need so
that the chart wizard will read multiple series where there is a
duration of time starting at a given time for a set number of dates.
Any suggestions?

http://pubs.logicalexpressions.com/...icle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html

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


"misscrf" <misscrf@yahoo.com> wrote in message
news:f2d27740-b618-4034-8d47-b3da716445ac@m45g2000hsb.googlegroups.com...
> What I mean to say, is how do I set up the spreadsheet, so that the
> chart can be created? I am not understanding what columns I need so
> that the chart wizard will read multiple series where there is a
> duration of time starting at a given time for a set number of dates.
> Any suggestions?