VB for plotting time line on xy graph...
 

Hey all,

By activiting a button within my workbook several xy graph charts are
generated. The data is taken from one sheet and the graphs/charts are
generated within a different sheet with the plotted data completed.

The y scale is numerical i.e. 0-100 and the x scale is date Jan06 - Jan08
(monthly intervals). Presently I am placing a 'timeline' on manually - this
line represents the current date when the graph is plotted.

My request for help. Is there a way to script this into my current VB where
it can verify Date() then Plot a line accordingly?

Help and advice much appreciated.