Thread: how to create chart using data on different worksheets in xls

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.

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 Buddha@discussions.microsoft.com> wrote in message
news:7DEC578B-BED6-4834-87CF-5F577CC0F833@microsoft.com...
>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.