Well, there might be a question why I don't do it manually! Its because I have 8 charts per sheet for 14 sheets in a workbook, and i'll have 4 workbooks! So, I really need your help as the excel gurus have done it before!