I want one macro to create a chart over a set the same amount of cells no matter what the worksheet or workbook is named. Is there some "activeworksheet" command that I can use in my code that will work no matter what the name is? So far the code is getting hung up on setting the source data with a specific worksheet name. any suggestion would be greatly appreiciated.