Jon Peltier has instructions for creating charts from data on different
sheets:


http://www.peltiertech.com/Excel/Cha...entSheets.html

Waiting for reply wrote:
how do I create a pie chart with data from several tabs


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