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.


--
sacrum
------------------------------------------------------------------------
sacrum's Profile: http://www.excelforum.com/member.php...o&userid=22861
View this thread: http://www.excelforum.com/showthread...hreadid=555963