I have a list of scheduled tasks. In one column is the time the task
started. In the next column is the time the task ended. Many of these
tasks overlap. (Two or more task are running at the same time,
starting and ending at different times.)

I want a chart that shows how the tasks overlap. I'm thinking of a
chart that has a standard time line for both x and y axis. The for
each time on the x axis where a task began there are two dots
connected by a line. The lower dot is when the task started, the upper
dot when it ended and the line represents the duration. Then I could
scan my eyes across the chart and see where the tasks are overlapping.

Anyway, this is just my idea of how it should look. I'd welcome any
suggestions on how to represent this data.

tod

Hi Tod,

Have a look at Jon Peltier's site and scroll down to Gantt charts.
I think that is what you are looking for.
http://peltiertech.com/Excel/Charts/ChartIndex.html

HTH
Martin



"todtown" wrote in message
...
I have a list of scheduled tasks. In one column is the time the task
started. In the next column is the time the task ended. Many of these
tasks overlap. (Two or more task are running at the same time,
starting and ending at different times.)

I want a chart that shows how the tasks overlap. I'm thinking of a
chart that has a standard time line for both x and y axis. The for
each time on the x axis where a task began there are two dots
connected by a line. The lower dot is when the task started, the upper
dot when it ended and the line represents the duration. Then I could
scan my eyes across the chart and see where the tasks are overlapping.

Anyway, this is just my idea of how it should look. I'd welcome any
suggestions on how to represent this data.

tod

Wow! That is EXACTLY what I'm looking for. Thanx.

On Feb 23, 8:49*am, "MartinW" wrote:
Hi Tod,

Have a look at Jon Peltier's site and scroll down to Gantt charts.
I think that is what you are looking for.http://peltiertech.com/Excel/Charts/ChartIndex.html

HTH
Martin

"todtown" wrote in message

...



I have a list of scheduled tasks. In one column is the time the task
started. In the next column is the time the task ended. Many of these
tasks overlap. (Two or more task are running at the same time,
starting and ending at different times.)

I want a chart that shows how the tasks overlap. I'm thinking of a
chart that has a standard time line for both x and y axis. The for
each time on the x axis where a task began there are two dots
connected by a line. The lower dot is when the task started, the upper
dot when it ended and the line represents the duration. Then I could
scan my eyes across the chart and see where the tasks are overlapping.

Anyway, this is just my idea of how it should look. I'd welcome any
suggestions on how to represent this data.

tod- Hide quoted text -

- Show quoted text -