VBA to plot graph wiht variable range of data
 

Hi there,

I am looking for advice as how should I go about in writting some VBA code
for plotting graph from data I pull out from some archive.

/my_test/all_test
04-Jul-06 30-Jun- 06 29-Jun-06 28-Jun-06
test_1 2.909143 3.727211 3.345108 3.638312
test_2 2.232157 2.110976 4.670067 2.463802


/your_test/all_test
04-Jul-06 30-Jun- 06 29-Jun-06 28-Jun-06
test_1 2.909143 3.727211 3.345108 3.638312
test_2 2.232157 2.110976 4.670067 2.463802


I wrote a perl script to crawl through some archive and extract the data I
am interested and dump them into a CSV file in the above format. Now that I
have the CSV file I would like to get excel plot a line graph for every
table, for example:


/my_test/all_test
Time
|
| --/\ ---------- test_1
| \ /
| ---\ \/
| \-------------- test_2
|__________________________
date


/your_test/all_test
Time
|
| --/\ ---------- test_1
| \ /
| ---\ \/
| \-------------- test_2
|__________________________
date

the number of columns & rows are different for every table.

Any suggestions?

I could easily modified the CSV file style if this will make the processing
in excel easier.

thanks