VBA to plot graph wiht variable range of data

K

Kok Yong Lee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros to convert Data into date format and then plot in graph 7
Converting CSV text 2
Sorting CSV Data By Date 8
Combine 2 Charts 2007 Excel 1
Add Subtotals after inserting row 13
match one column with dates to several colums with dates, copy pas 4
Summing weekly values to fall into correct month 2
Averaging data if within a date range 6

Top