Tushar:

If Nick is doing it as a Gantt chart, the date-time is the Y variable,
and it's fully numerical. A horizontal bar chart should be okay.

Nick:

Are you merely plotting the durations? Then skip a column, column F
should be some kind of label for the vertical axis of the bar chart,
column G should be the difference between columns A and B, and column H
the difference between C and D. Select the data in columns F:H and make
your stacked bar chart with series in columns.

More about Gantt charts:

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

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


Tushar Mehta wrote:

It is not clear what exactly you are doing but then it may not matter.
;-)

If your dates and *times* are not showing up correctly, it is because XL
does not have a way to plot times within a day correctly except for a XY
Scatter chart. Instead of using a floating bar chart can you use a step
chart? For how see
Step chart
http://www.tushar-mehta.com/excel/ch...art/index.html