Here are some guidelines:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Earl" wrote in message
...
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