Add Data Series to Graph Upon Macro Insertion

I have a project that inserts cells in our data upon a failure. I'm wondering if it's possible to add the inserted cells to the linked graph as a new series. For example, as we look at our example spreadsheet, the final data point we took fell outside of our specification range, so the macro added 10 more rows to resume testing. I need the graph to also then add those rows as separate data series for the boxplot graph. Note: the subset 1 graph should only pull from rows B:I and subset 2 from K:S. Please let me know if I can clear any of this up, I sincerely appreciate any help you can provide!