Hello,
I need excel to generate graphs automatically when transfering data from a certain folder.
- I have data that is in .DDF which I conver to .asc which I have wrote a Macro to convert that into excel. After doing that I get 4 column s of data:
1. Time it takes to perform a test --> Column A
2. The force (in Newtons) --> Column B
3. The Angle (degree) --> Column C
4. The angular velocity --> Column D
I get these columns of data per each file I have which it automatically excel puts them in different sheets for me, however, I wanted to know if excel can generate graphs by taking data from certain columns and generate graphs automatically.
The data that comes in is either velocity (V...) or Force (HL...), which the files name it self starts with V... or HL.... However, to generate the graph for V... you need to get Column C as x-axis and Column D as y-axis.
To get HL... graph you need to graph Column C as x-axis and Column B as y-axis.
There is different number of Rows per file, however, the columns are all the same for all of them.
Attached is an excel sheet with data and graphs which I generated Manualy.
Thanks a lot for all your help.
Irfan
Bookmarks