S
sacrum
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.