OVERLAY TWO CHARTS(GANTT)
 

OK,

So I have:


ID Column| Start Date |Days Run |Start Date2 | Days Run2
001 10-Jan-84 15 19-Jan-84 15
001 11-Jan-84 14 21-Jan-84 15
002 11-Jan-84 29 14-Jan-84 29
002 11-Jan-84 29 14-Jan-84 29
.....


I make the first Gantt which has ID Column on the y-axis and then Start
Date column on the x-axis and Days Run plotted in a bar(---- below).
Crude example below of first line because I can't paste the chart into
here.


001 -------------------------

|10-Jan-84 |25-Jan-84



when I paste special the 2nd(+++ represent Days Run2) in I get:

001 -------------------------+++++++++++++++++++++++

|10-Jan-84 |25-Jan-84 |09-Feb-84






which is wrong. I want:

001 -------------------------++++++++++++

|10-Jan-84 |25-Jan-84 |03-Feb-84


If someone could help I would REALLY appreciate it!!
I can email you the Excel file with the plot and what I actually want.

-Mike