Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 130
Default Timeline Chart?

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
timeline chart jtaiariol Excel Worksheet Functions 0 June 20th 07 06:39 PM
timeline Boswell Charts and Charting in Excel 0 June 10th 07 03:14 PM
Timeline chart of projects stremetzky Excel Worksheet Functions 0 April 18th 07 06:47 AM
Can I link timeline labels to a line chart? hizzle Charts and Charting in Excel 1 December 6th 05 09:36 AM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 09:20 PM


All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"