ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   In a GANTT, how do I get diff projects to start later on chart (https://www.excelbanter.com/charts-charting-excel/48076-gantt-how-do-i-get-diff-projects-start-later-chart.html)

Tim

In a GANTT, how do I get diff projects to start later on chart
 
I want to show a flow of projects, by date. When one stops, the other starts
or maybe the next starts a couple days before. How do you set up the GANTT
to show the stepping effect. Currently all I can get it to do is all
projects start at the same time. Thanks for the help

Jon Peltier

A project bar in a Gantt chart is the stacked bar defined by a start date and a
duration. To make a bar start later, give it a later start date. You should be able
to use formulas to relate a later start to the earlier starting date and duration of
another bar.

These articles might be of assistance:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tim wrote:

I want to show a flow of projects, by date. When one stops, the other starts
or maybe the next starts a couple days before. How do you set up the GANTT
to show the stepping effect. Currently all I can get it to do is all
projects start at the same time. Thanks for the help




All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com