Each data series has a column of dates and a column of percent complete
values. I'll use columns A and B in this example. Insert a couple rows so
that the headers are in A3 and B3 and the data starts in row 4. Insert a
column between A and B. In B1 enter the date of reference. In B3 enter a
header like 'Elapsed'. In B4 enter this formula

=if(A4<B$1,-B$1-A4,A4-B$1)

Format as a number (not a date) and drag to fill as much of column B as you
need. Select the data in B:C and create an XY chart (marker with line or
just line).

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


"Mike Hartsough" wrote in message
...
I'm a chart neophyte.

I have a worksheet with multiple line charts, each line depicting total
hours per month per project.

I would like to align the lines to a common milestone, like "start of
detailed design". Each project of course has a different date for this
milestone.

Other than knowing that somewhere I'll have to specify the dates of the
milestone for each project, I have no idea of what to do.

Any help/insight will be appreciated.

Thanks,
Mike