Hi, i am creating a (line)chart from a worksheet in excel using win32-OLE. Say my worksheet has columns A-F. i want to create two charts like: chart 1 : column A,B ....&&..... chart 2 : column A,C,D,E,F .......... because we specify range while creating charts,like $Chart1->SetSourceData($Sheet->Range('A1:F9'),xlColumns); i am unable to skip the column B in chart 2. is there a way i can do this ? thanks :)