Need help with management dashboard workorders

Dear all, i am new here, and i am learning how to use this forum.  sorry for that. 

I have a database (reduced version in excel attachment) with workorders for which I would like to create a management dashboard.

I want a number of graphs on the dashboard, see also examples of images in the attachments:

• trend graph Registered vs completed (in Dutch ‘Aangemeld vs. Afgesloten’).; How many workorders were reported in a month but also how many were closed in that month. This shows the growth or decrease in the last months.
• trend graph workstock (feasibility) (in Dutch ‘Werkvoorraad, Haalbaar/ niet haalbaar en zonder streefdatum); Per month also the number of workorders that shows how many were feasible [light blue], not feasible [dark blue] or had no target date [orange] in that month based on the planned target date.
• trend graph Timeliness (in Dutch ‘Tijdigheid’ ; op tijd, te laat, geen streefdatum); per month the number and percentage of workorders that were on time based on the planned target date. on time/too late, without target date with a trendline and a normline.

In the excel I have a database with various data of the workorders including the notification date {melddatum), a planned completion date and an actual completion date.

With those data fields I want to make the evaluations

The example graphs give an example in Year&Month. but the wish is also to be able to display them in Year&Weeks or years.

The difficulty for me is the date calculations that are displayed dynamically but are fixed in my database. Because something that is reported in January but only reported in June runs through several months. and that now distorts my graphs.

It would be great if you have input and can help me move forward. Thanks in advance.