ok ive got 2 columns populated with planned dates and actual dates, all
converted to the friday of each week so i can get a count of how many
were planned/actual in a given week.

the major problem i have now is trying to plot the 2 series on the line
graph. to get the counts of each date ive had to use 2 pivot tables,
one that counts the dates in planned column and one counting the dates
in the actual column.

2 problems with this are, i cant plot a graph from 2 different pivot
tables, and even if i could, the ranges of weeks do not match, i.e. the
2 pivot tables show

planned count actual count
6 jan 06 6 18 nov 05 24
20 jan 06 2 25 nov 05 13
27 jan 06 2 2 dec 05 37
3 feb 06 1 9 dec 05 12
16 dec 05 12
23 dec 05 10
20 jan 06 2

so as you can see, i somehow need to group up the dates from both
planned and actual to use as the X axis catagories, and then plot the 2
series under the correct dates


--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=505716