View Single Post
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Organize your data as below. Note that you have to use a date together
with the time (you are crossing midnight after all)

Name Start Duration
MC1 1/1/2005 23:45 01:43
MC2 1/1/2005 23:55 01:32
MC3 1/2/2005 00:05 00:23

Now, create what XL calls a bar chart (horizontal bars) and for the
subtype select 'stacked bar' (step 1 of the wizard). Ensure that in
step 2 of the wizard XL has data in columns selected.

Once done, double-click the first plotted series and from the Patterns
tab set both the Border and Area to none.

For a tutorial see
Floating bars tutorial
http://www.tushar-
mehta.com/excel/newsgroups/floating_bars/tutorial/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Name Start Duration End
MC1 23:45 01:43 01:28
MC2 23:55 01:32 01:27
MC3 00:05 00:23 00:29