C
Chris_john Turner
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.
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.