Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I plot a 3D graph when I have 3 columns of data? | Charts and Charting in Excel | |||
what's wrong wiht my bar graph in excel? | Charts and Charting in Excel | |||
How do I plot both line and column data on same graph? | Charts and Charting in Excel | |||
Want to plot a graph using data from 2 different worksheets in sam | Charts and Charting in Excel |