<chuckle> Good evening, newpup. Speaking only for myself, I didn't answer because I don't have an answer. I don't know much about the available add-ons to Excel, except one that Microsoft provides. And speaking or at least guessing for the others, I imagine they didn't answer for the same reason.

But since you're asking, let's at least try to give you some feedback. Your question, I think, is this: "I have some charts and graphs that are the result of tens of thousands of data points. Are there any add-ons to Excel that will analyze the contents of these cells and call my attention to those cells which cause a chart, or portion of a chart, to depart drastically from whatever norm has been established by the others? I realize this analysis would take a long time."

I probably didn't do a good job with your question, and if so I freely admit it's because I didn't understand your question all that well. But it sounds like you need an add-on that will save you a ton of work by doing the analysis in your place. Now, computers can do analysis much, much faster and more reliably than humans, so that part of your question is right on point. But they invariably have to be told how to do that analysis first. You cannot skip that part—and it sounds very much to me as though that's what you're attempting.

If you can describe exactly what sort of analysis will tell you what you need, then maybe you'll find there is already such a program out there for you; and if not, you (or someone) can write one to do what you need, and it will still save you months of work. But you gotta describe what you need first. Something like this: "What causes the blip in the 'JIT offset' line between 2014 and 2017 in chart #7? To know that, I need to find the average values on worksheet "JIT targets", columns F:H and AB:AD, and see where the data exceed the mean values by more than 150% for at least three consecutive rows." Obviously I'm just making that up; the point is that you have to know what it takes to "analyze" the data. Once you've figured that out you (or someone) can tell Excel to do it for you in seconds or hours instead of weeks or months. But until then, all any of us can do is ask helplessly "but what analysis do you want to perform?". And the computer will do no better.