How do I create a chart using cells from multiple worksheets?

[Paul]

Does anyone know how I can select cells from multiple
worksheets in the same spreadsheet and show the data in a
chart?

 

[Jon Peltier]

Paul -

You have to generate a summary sheet, which is linked to the values on
the other sheets. This summary range is used to create the chart.

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html

- Jon