Jon Peltier has instructions for charting data from different sheets:


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

tclbeach wrote:
Using Excel 2003 how do I create one pie chart by using data from 2 different
sheets? all of the examples i see are created by clicking and dragging data
from one sheet.


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