I'm only having a chuckle because I'm in a similar situation. We've got data everywhere and I find that manually summarizing it is a waste of time and have had to do exercises like this to make heads or tails of it.
Where is the source data and where is the data that feeds the charts? I'm not sure if I understand, can you post a sample or something?
Bookmarks