Thread: Creating a chart with data series from several worksheets

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

No. Series can come from different sheets but data within a series must be on the same sheet.

So building a consolidated range is the way to go.