Create Chart for each row using VBA

[Shashwat]

Hello Everyone,
I am new to VBA. I have a spreadsheet where I need to generate chart for the maximum and minimum set of values which are in the same row but the number of rows keep changing. I mean sometimes there are 10 rows in a sheet and sometimes 50.
But the data sets remain same :
For first data set, X values range from AI to AP column and its Y values range from AQ to Ax column. And for the second data set, X values ranges from AY to BF and Y values range from BG to BN. And the row generally starts from row 3.
I tried searching for the program but couldn't find one.
Any help is greatly appreciated.

 

[Hui]

Shashwat

Firstly, Welcome to the Chandoo.org Forums

What you have described is known as Dynamic Charts, where the ranges for each series change as data is added or removed from the series

I'd suggest starting here:
http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

 

[Hui]

Then have a look at the Mockup I made of the first 3 sets of data

See attached file

 

[p45cal]

…another take in attached (only because it might be difficult to identify which each of 50 lines on a chart is) and I didn't want to create 50 charts as the subject of this implies.
Select a different cell to get a different plot.