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

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

## Bookmarks