Hi Everyone,

I have an Excel workbook of 30 worksheets that I would like to put the same type of chart on. However, the number of columns in each of the worksheet differs. Do you know a way I can use a VBA macro to create the same type of chart, for each of the 30 sheets, while allowing the number of columns to differ in each of the worksheets? I have the VBA code to do the chart already and it does work, given that my data dimensions are static. Unfortunately, my data is not that way though.

Thanks,

tiredone