My suggestion would be just to build charts from the Excel tools - I can't see why VBA is needed from your data structure. Am I missing something?