Generate Graph Automatically

Hello,

I have a problem with excel generating graphs automatically. Current path I take in generating these graphs is manual graphing, and I would like the graphs to be generated automatically .Here is what I want the excel to generate:

1. I have several different .asc files I have to analyse with graphs.
2. I have writen a macro to importa these files from a certain folder.
3. Column A, B, C, D never change format.
4. There is 3 different graphs I want to generate: HL_C, HL_O and V

See attached XL file and this contains the graphs I want to generate automatically. The .asc file numbers will be changing everytime I import, but the format will stay the same.


Thanks for all your help.

Irfan