Hi all,

First I wanted to create as I descripe an difficult chart to make:

I have a list of change records with 2 different date columns (start date & close date).
I want a bar chart that shows me on a weekly base how many change records were still open. So for every week the chart has to check if a records has a startdate that starts in that same week or before. If it has it should count it otherwise ignore it. Also for all the records it finds as just stated the chart should check if the record has a close date that is within the same week or before. If is has than that record should also be ignored.

I really can't figure out how to create this kind of chart.

----------------------------------

When I did not know how to make the above chart I tried to create the followling chart:

I have a list of change records with 2 different date columns (start date & close date).
Now I want to create a bar chart that show me on a weekly base how many change records were created and how many were closed that week.

I also don't know how to figure this one out.

----------------------------------

Please help me, I really would like the first chart, but if not possible please help me with the second one. If you need for information please ask and I willl provide it were I can.