I am retrieving 6 sets of information from a database server. and currently all my script can do is retrieve them and put them in excel sheets and make charts specific to a column...now what happens is that if there are 6 sets of information...there are 12 excel files which are formed(one containing info retrieved and other containing graph)..what i need to do is all the charts should be in one excel file and those charts shud be there in different tabs..i am attaching the sheets so tht i can explain it to you more

I have attached 4 charts..now these charts are retrieved from the database when i loop from 1 to 4..all i need to do is instead of having them in sep excel files..i need them in one workbook and in different sheets..if u see sheet1 of every chart has information regarding how chart is formed...kindly help me in this one..i have been stuck since a month..