Hello,

I do a lot of simple raw-data presentations in my projects where I simply want to show the data fast before I go into deeper analysis. For this I want to simply dump my data (a new sheet for every dataset) and have a graph update with my data as I add sheets. To do this manually gets very tedious. On every sheet I want to add the same range, let's for simplicity say I want to add columns A1:A5 against B1:B5 from "Sheet1" , "Sheet2"... and so on. How would one go about creating such a chart, I'm assuming it's through some kind of VBA script but I have never delved into VBA-scripts before. Does anyone know of any thread which goes through similar topics, I was unable to find any.

With Regards
/Z