Overlapping Time Chart?
in [Charts]
|
Prev: Excel 2007 - Printing graphs with no data or graph lines
Next: Dynamic Charts - Changing Number of Series
From: misscrf on 2 Jul 2008 17:47 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!
From: Del Cotter on 2 Jul 2008 18:47 On Wed, 2 Jul 2008, in microsoft.public.excel.charting, misscrf <misscrf(a)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/microsoft.public.excel.charting/browse_t hread/thread/7528156a909aed7b/8cbd3b109557d853?#8cbd3b109557d853 -- Del Cotter NB Personal replies to this post will send email to del(a)branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead.
From: misscrf on 3 Jul 2008 08:54 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!
From: misscrf on 3 Jul 2008 14:11 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?
From: Jon Peltier on 4 Jul 2008 13:45
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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(a)yahoo.com> wrote in message news:f2d27740-b618-4034-8d47-b3da716445ac(a)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? |