Jon Peltier has information on charting data from different sheets:

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

michael wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html