creating multiple line charts
 

Hello.

I am trying to make multiple charts with a large worksheet. It would
need to be auto update of over 100 data sets. Is there a simple way to
do this without making each and every chart :(

Here is the type of data:
x-axis is static (column A)
y axis is dynamic
- data set1 col B2 - B??
- data set1 col C2 - C??
- data set1 col D2 - D??
- etc
auto min/max values

Data Set 1
==========
Chart title = $A$1 + B1;
Series Name = B1;

Please let me know there is an easier way. btw, I have no experience
using macros. Help appreciated!