Generating Individual & Aggregate Charts

Hello,

I've been able to successfully scavenge bits and pieces of code from various fora to compile the hulk below. Essentially, it pulls emissions data for various sources from one parent sheet, parses that data out (one sheet per source), and creates a chart for each pollutant emitted from each source (Y = emissions, X = time). I'd like it to do the same parsing and chart generation for all sources listed in the parent sheet. I've taken a stab at it below, but it's not very elegant, nor do the charts generated actually reflect the total--with only one series, there's no actual "stacking" of the columns, just superimposition. Any ideas on how to easily incorporate that functionality and possibly condense the code? Thanks in advance, cc.

Please Login or Register  to view this content.