A
Amy
how do i create a graph that pulls data from multiple
worksheets to show a timeline of project phases?
example:
Sheet 1
column A column B column C
row 1 Task # Start Date End Date
row 2 1 11/15/03 11/25/03
row 3 2 12/29/03 02/04/04
Sheet 2
column A column B column C
row 1 Task # Start Date End Date
row 2 1 12/15/03 12/25/03
row 3 2 01/18/04 02/24/04
how do i create a chart that shows the dates of Task 1
from Sheet 1 AND Task 1 from sheet 2? THANKS!!
worksheets to show a timeline of project phases?
example:
Sheet 1
column A column B column C
row 1 Task # Start Date End Date
row 2 1 11/15/03 11/25/03
row 3 2 12/29/03 02/04/04
Sheet 2
column A column B column C
row 1 Task # Start Date End Date
row 2 1 12/15/03 12/25/03
row 3 2 01/18/04 02/24/04
how do i create a chart that shows the dates of Task 1
from Sheet 1 AND Task 1 from sheet 2? THANKS!!