MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Vertical Gantt chart


Posted by noir on January 10, 2002 7:39 AM

I am making a Gantt chart and i would like the bar's to show vertically. The chart guidelines are very simple. My chart reads from 10-100 as follows;

*On left side vertically, A15=100, A16=90,A17=80,A18=70, etc.
*On bottom horizontally, B25=10,C25=20,D25=30,E25=40, etc.

So far i have: =AND(A$24>=$B25. What is the rest?

Thanks,
Noir


Posted by Noir on January 10, 2002 7:57 AM

*Figured it out, thanks!!* (NT)