excel graphic planner

[stremetzky]

Hi,
I'd like to plan several projects and get graphical overview.

For example there is:
in cell A1 starting date&time of a poject,
in cell B1 ending date&time of a poject.

Cells C1 to I1 represent days: Monday, Tuesday,...

Let's say a project starts on Tuesday 10 AM and finishes Friday 4 PM.
I would like in the cells which represent days marked the period of a
project duration with another color.

tnx for help,
stremetzky

 

[Pete_UK]

Jon Peltier has instructions in his Gantt chart article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

....and you might be interested in these links on his Website:

http://www.peltiertech.com/Excel/Charts/GanttLinks.html

Hope this helps.

Pete

 

[stremetzky]

It helps me a lot, but I still have one problem. In my projects the
end date&time of one project is also the start date&time for the next
project. How can I draw a chart with only x axis with marked points
for start and end dates?

tnx



Pete_UK je napisal: