We usually make a book with the graph sheet all setup and customized and then drag and drop new data files to the book. This will involve much less coding and allow later to make changes to the graph without knowing the code.
We usually make a book with the graph sheet all setup and customized and then drag and drop new data files to the book. This will involve much less coding and allow later to make changes to the graph without knowing the code. CP
OK. Can you share an example of such a book, please?
I design my workbook in such a way that each sheet contains data and an embedded plot illustrating the data on the sheet. Therefore I make the import filter to import data on a separate sheet and create the graph as per specified template.