Hi,

Jon Peltier's page on the topic should help.
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Cheers
Andy

rvExcelNewTip wrote:
Is it possible to draw a chart in WorkSheet1, based on data residing in
WorkSheet2?

I tried by Naming (Define Name) the data in Sheet2 and then using these
Names for the Series. But the Charting Wizard always replies with Wrong
Formula!
Entering the ranges (prefixed with the worksheet name) doesn't help
either.

I certainly must be doing something wrong, isn't it?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info