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/ChartsH...iffSheets.html

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

"Nilesh Buddha" <Nilesh wrote in message
...
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.