Ann_BBO
04-23-2009, 01:45 AM
Hi All,
I have one marco to input the log data from text file into workbook.
Each log has a Date to indicate it. Now, I have over 1 year data log and would like to extract a 4 data log into X-Y scatter graph. The 4 data log which are “Most Recent”, “One-Month Before”, “Half-a-Year Before” and “Earliest Reference” curves in the graph referring to Date's data log.
Suppose Range (“B1”) = 4/21/2009
4/21/2009 4/1/2009 3/19/2009 10/12/2008 4/1/2008
1 -45.62 -58.89 -68.83 -65.61 -60.61
2 -47.11 -54.90 -56.90 -63.52 -62.52
3 -50.55 -57.31 -57.31 -68.83 -68.83
Most Recent = 4/21/2009 data log
One Month Before = 3/19/2009 data log
Half-a-Year Before = 10/12/2008 data log
Earliest Reference = 4/1/2008 data log.
X=axis = 1,2,3
I don't know how to compile it. I have try the Month function in excel but the problem is data log is very large.
The stimulated attachment is enclosed. Hope that all can help.
Thanks
Ann
I have one marco to input the log data from text file into workbook.
Each log has a Date to indicate it. Now, I have over 1 year data log and would like to extract a 4 data log into X-Y scatter graph. The 4 data log which are “Most Recent”, “One-Month Before”, “Half-a-Year Before” and “Earliest Reference” curves in the graph referring to Date's data log.
Suppose Range (“B1”) = 4/21/2009
4/21/2009 4/1/2009 3/19/2009 10/12/2008 4/1/2008
1 -45.62 -58.89 -68.83 -65.61 -60.61
2 -47.11 -54.90 -56.90 -63.52 -62.52
3 -50.55 -57.31 -57.31 -68.83 -68.83
Most Recent = 4/21/2009 data log
One Month Before = 3/19/2009 data log
Half-a-Year Before = 10/12/2008 data log
Earliest Reference = 4/1/2008 data log.
X=axis = 1,2,3
I don't know how to compile it. I have try the Month function in excel but the problem is data log is very large.
The stimulated attachment is enclosed. Hope that all can help.
Thanks
Ann