Large data handling in Excel, producing graphs from “scrambled” data

[Mr Niceguy]

I have a project here where I receive large data files in Excel. I have to sort these and produce graphs, showing trends over time etc. The data I receive is "scrambled" in the sense that it is data for several different "profiles" at once, and I first have to manually sort each of these into their own tab in excel. I then use pivot tables and graphs to interpret the data.


Is there a way to produce graphs that read this data directly from the source file? The graphs would have to sort out data based on parameters from several different columns at once, to make sure it only reads data for a specific "profile" under certain conditions.


I realize that Excel might not be powerful enough to do this on its own, and that I may have to look into some actual programming, but I need some help on where to look.
Thanks for any help!

 

[Mr Niceguy]

Bumpety bump