Need help with build and deplete charts output|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Right now i have a excel table from which i use sumif formula to extract numbers based on date and few othe criteria to filter values by date.
I also have three sets, which has a upper limit of 70000, so each time a set reaches max, the next set will start adding and so.

Each time set gets to max limit, it needs to deplete based on daily value and so on.

As each set follows a loop of build and deplete, i am currently working manually each week to output graphs to show the build and deplete values in graph format for each set.

Any help to automate this graph is much appreciated.

Regards
Shanny