Time chart

[geo]

I need a time chart as in example

A1= Henry B1=15 C1=21
A2= Sally B2=12 C2-=18
A3= George B3=11 C3=16
A4= Alex B4=10 C4=14

Henry ------------------------
Sally -----------------------
George --------------------
Alex -----------------

10 11 12 13 14 15 16 17 18 19 20 21

 

[Jerry W. Lewis]

You could simulate the chart with an XY Scatter chart of the data
15 4
21 4

12 3
18 3

11 2
16 2

10 1
14 1

Format the y-axes to show no labels on tick marks, drag the left edge of
the plot area in to leave room for your text lables, which you add as
text boxes.

Jerry

 

[Earl Kiosterud]

Geo,

Try "Floating Bars." In the Chart Type dialog, change to tab "Custom
Types."

 

[Jon Peltier]

What you need is a gantt chart. Here's a simple tutorial:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

and here are links to other sites:

http://peltiertech.com/Excel/Charts/GanttLinks.html

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