Overlapping Time Chart?

M

misscrf

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!
 
M

misscrf

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!
 
M

misscrf

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Make Y-axis values correspond to x- axis value 1
Employee Schedule not plotting properly - chart type / data series not correct 0
charting multiple identical x values overlapping 0
Graph usage for times of day 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
sideways stacked bar charts with line series on the same axis 0
Checking for date and time overlaps 0

Top