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 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/mic...rting/browse_t
hread/thread/7528156a909aed7b/8cbd3b109557d853?#8cbd3b109557d853

--
Del Cotter
NB Personal replies to this post will send email to ,
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/P...cle.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" wrote in message
...
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?