I have tried to write a macro to build the graph automatcially based on using offset series
however i am unsure as to why it needs to pull the name of the xls, as i need this to be dynamic as every day i would like to be able to run the macro to create the graph.
Please Login or Register to view this content.
Any ideas on how i get round this?
ps i have posted this to a reply to an original issue i had with have variable amounts of data when trying to create a graph. Apologies if this breaks any rules