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

Jon Peltier has instructions in his Gantt chart article:

http://pubs.logicalexpressions.com/P...cle.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

On Apr 16, 12:15 pm, "stremetzky" wrote:
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

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:
Jon Peltier has instructions in his Gantt chart article:

http://pubs.logicalexpressions.com/P...cle.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

On Apr 16, 12:15 pm, "stremetzky" wrote:
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