I want to combine varied data from separate workbooks into one chart.

Data is collected at varied date intervals and level ranges (11/03-2/07) &
(0-100). Data begins with 24k rows and is filtered to 1K.

Individual charts display daily data labeled as varied mm/dd/yy on the
€˜Category Axis and 0-40, 0-60 & 0-100 on the €˜Value Axis. Adding additional
€˜Series just gives one horizontal line.

TIA