Macro to create more charts

Hi all,


Hope, that anyone could help me with the following issue I'm facing.
I have a macro, which creates me a 2 charts for 2 metrics ( 1 chart for each). My metrics are in columns as below. Is there a way to have dynamic macro, which will create me number of charts depending on number of columns?

Week Number of Calls Number of Serial numbers
W1 10 410
W2 45 446
W3 101 85


The point is, that number of columns ( metrics) always change, this could avoid a lot of manuall work

Thanks a loooot to all
Andy

Hi,

Is there anybody who could help with that?

Thanks, Andy