Graphing Problem

[Kicker]

I need a custom graph to represent timelines similar to those found in MS Project. BUT...I need to do it in Excel.

Example:
I will have a spreadsheet with anywhere from 20 to 100 rows of data.
Col A will have an identifier number
Col B will have a start date
Col C will have a start time
Col D will have an ending date
Col E will have an ending time

The left edge of the graph will represent a selected date. Each element of the graph will represent a specific item by identifier number shown in reference to the selected date. such as...

item 1 XXXXXXXXXXXXXXXXXXX
item 2 XXXXXXXXXX
item 3 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
item 4 XXXXXXXXXXXX

etc.....

MS Project does a pretty good job of representing the items, but it means we have to do the data entry "again". OR, can we use the data from an Escel Spreadsheet as the datasource for a MS Project file???????

Advice please
ttfn
Kicker

[Jacob Hilderbrand]

Can you attach Zip file with the Excel file showing the way the data is set up.

[Kicker]

Actually, that is why I used the word "will" have... It doesn't exist yet.

I will be able to post something tomorrow night but don't have anything except a concept I'm working on.

Item1 8/3/04 10:00am 8/10/04 4:00pm
Item2 8/7/04 12:00pm 8/9/04 10:00am
etc.

Hope this helps and will have some sort of excel sheet by tomorrow night.

ttfn
Kicker

[Jacob Hilderbrand]

Like this?

[parry]

Nice Jacob :-)

Heres some instructions on creating a gantt chart in Excel
http://courses.smsu.edu/mas006f/files/ganttinstr.pdf

[Kicker]

You guys are good.
Thanks a million....I mean a whole lot
ttfn
Kicker

[Jacob Hilderbrand]

Glad to help.

Take Care