Graph series

Hi,



I have tried to write a macro to build the graph automatcially based on using offset series

Please Login or Register  to view this content.

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.

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

Thanks

Antony