I have a weeks worth of mesurment data taken at one minute intervals.
Every day at midnight a new .CSV file is created by the data logging program.
I import each CSV as a worksheet in one big workbook
I would like to chart a these measurments for the entire week.
So far the only way I have come up with is to copy the colums I want to make into one data series from each daily worksheet into another worksheet and creat the chart.
Is there a way to make a chart where one Data Series can span several worksheets?
Edit: Sample file added
Bookmarks