Hi,

I have to plot multiple charts having multiple data series (8 or 9 X-Y). I am able to plot one single chart for a defined range, for which the vb macro code is pasted below. What I really want to do is to make this range selection (columns) dynamic. For example for the fist chart I select the range 
Please Login or Register  to view this content.
, but I don't know how to select several multiple ranges (for e.g. 
Please Login or Register  to view this content.
and so on to create multiple charts from the data in the same worksheet? I am really new to VB coding. I desperately need help. The macro code is:
Please Login or Register  to view this content.
I acquired this code thanks to the hyper informative page: http://peltiertech.com/Excel/ChartsH...html#manyxoney

The sample excel file is here: Sample.xlsx

I hope to be able to solve this at the soonest.

Thanks in advance,
Sanjeev