I have a list of 262 different calls. For each I have:

Start Time
Rung Till
Call Lasted Till

What I would like to do is have a graph, where each call is like a "Bar",
showing the call ringing in Red, and the time after that (contact) as Blue.
Obviously a bar graph isn't good enough because it would show all the calls
starting at the same time, and I want to see when the calls actually were.

The only thing I could think of doing was by colouring in cells, but 262
calls is 263 columns, and 1 hour 30 minutes seperated in seconds is alot of
formulas that made my excel crash.

Is there a graph I can use like some sort of Timeline?

See
http://peltiertech.com/Excel/Charts/BoxWhiskerV.html

PaulW -

You may be able to use some of Jon Peltier's Gantt chart examples. See
http://peltiertech.com/Excel/Charts/GanttChart.html
and
http://peltiertech.com/Excel/Charts/GanttLinks.html

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"PaulW" wrote in message
...
I have a list of 262 different calls. For each I have:

Start Time
Rung Till
Call Lasted Till

What I would like to do is have a graph, where each call is like a "Bar",
showing the call ringing in Red, and the time after that (contact) as
Blue.
Obviously a bar graph isn't good enough because it would show all the
calls
starting at the same time, and I want to see when the calls actually were.

The only thing I could think of doing was by colouring in cells, but 262
calls is 263 columns, and 1 hour 30 minutes seperated in seconds is alot
of
formulas that made my excel crash.

Is there a graph I can use like some sort of Timeline?