How do I create 1 chart from 2 different sheets?

[tclbeach]

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]

Jon Peltier has instructions for charting data from different sheets:


http://www.peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html