How do i automatically populate Moving average charts from large data sets?

I am using a spread sheet to record equipment failures and Production down time in a large facility with many pieces of equipment. The sheet is updated daily from an engineering report so has thousands of entries. I am trialing using moving average charts (30 and 10 days) to indicate when equipment is becoming problematic. At the moment I am using pivot tables to manually populate this which is very time consuming. Is there a way of automatically populating these for every individual piece of equipment?

There is a small example of the sheet in a later post - 2016 shift report.

The measure is Production Down time hrs.

Equipment is listed under Machine

Apologies for the knot I got myself in uploading the attachment