Automatic chart generation from 200 columns

Hello everyone,
Assume we have these columns:

A B C D E
--------------
1 3 5 7 9 ...
2 4 6 8 0 ...
3 5 7 9 1 ...

I would like to have the 1st chart from the first two columns so that A values are on the x axis and B values on the y axis (details are not important indeed).
I would like to have the 2nd chart from C and D columns ...
3rd chart from E and F columns ..
etc

or in another scenario, I would like to have everything versus A values so for instance the 1st chart is B vs A, the 2nd is C vs A, the 3rd is D vs A etc.

The reason I need this is because I have 200 columns and therefore I need to have 100 charts ... The charts need to be separate (I don't need everything on the same plot)
I'm wondering if there is anyway to automatically do this.
Any help is greatly appreciated
Thank you

Hi Andy, thanks for the response

- Having one chart with the option you talked about seems fine. Could you please gimme some hints on how to do that?

- I think chart objects is what I had in mine as chart sheets will be a pain to go through ...

- I didn't really think it through how they should be laid out..it's a good question actually ... whatever you suggest .. you know I'll pick maybe 10 of these 100 charts and make one single chart out of them but before doing that I need to know how each of them looks like and that's why I wanted to have kinda all of them in front of me ...

- XY scatter is fine or a simple curve or whatever ...

I just read this again and realized haven't said thanks :D
So thanks Andy. It was very helpful.