Same chart, multiple worksheets, dynamic data ranges

[tiredone]

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

[JBeaucaire]

Post your sample workbook with 2-3 pages in it and the code you're using currently, I'll see if I can adapt it for you to be dynamic.

[tiredone]

sample code:

Please Login or Register  to view this content.

sample workbook, worksheet 1 'GROUP 1'

YEAR RED GREEN YELLOW
2012 30 30 40
2013 40 30 20
2014 30 35 35


WORKSHEET2 'GROUP 2'
YEAR RED GREEN YELLOW ORANGE
2012 30 30 30 10
2013 20 20 30 30
2014 30 35 35 0


WORKSHEET 3 'GROUP 3'

YEAR RED GREEN YELLOW ORANGE PURPLE
2012 0 0 30 20 50
2013 20 20 30 30 0
2014 20 35 10 0 35

[JBeaucaire]

Like so:

Please Login or Register  to view this content.