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.