how to create chart using data on different worksheets in xls

[Nilesh Buddha]

I get weekly data of different diseases from different places that I enter
indifferent worksheets in an excel file. I want to see the continuous trend
(disease and place wise). For that, without entering data again, I need to
create a chart using data on different worksheets. How do I do that? Can you
please help? Thanks.

 

[Jon Peltier]

You may have to construct a helper range one another worksheet. With some
clever formulas, it shouldn't require too much work to maintain.

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______