PDA

View Full Version : Solved: Graphing Problem



Kicker
08-03-2004, 11:39 PM
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
:vv

Jacob Hilderbrand
08-03-2004, 11:47 PM
Can you attach Zip file with the Excel file showing the way the data is set up.

Kicker
08-03-2004, 11:58 PM
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
08-04-2004, 12:51 AM
Like this?

parry
08-04-2004, 02:05 AM
Nice Jacob :-)

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

Kicker
08-04-2004, 07:41 AM
You guys are good.
Thanks a million....I mean a whole lot
ttfn
Kicker

Jacob Hilderbrand
08-04-2004, 08:37 PM
Glad to help. :)

Take Care