Creating a pvot with two axis to show opened and closed by week

Hi there, I'm trying to create a pivot table and grpah that shows when a work item was created vs when it was closed (on a secondary axis which is a line), and I just can't seem to get it to work! I've attsached an extract with my progress, could anyone give me any pointers? I'm not sure if it has something to do with the format of the closed date column as when I put that into the pivot on it's own I'm unable to group the dates by week, month, etc.

Any help would be greatly appreciated!

Originally Posted by JeteMc

By replacing the dashes (-) with zeros which are hidden using custom formatting; then selecting refresh all for the pivot table; then placing the closed field in the Rows area and the closed flag field in the Filters area I was able to group the dates.
However, I don't understand how you want a pivot chart to display this data.
It may help if you could use a smaller data set and then draw us a picture of how you would like that data displayed in a chart.
Let us know if you have any questions.

Thanks for the response and info on how to format the closed date column. Essentially I'm trying to get one graph that shows how many items were created (column E) on any given week vs how many were closed (column F). It's easy to get one graph showing how many were opened and another showing how many were closed, but is there a way to combine them into one graph?