Timeline Chart?

P

PaulW

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top