how to create chart using data on different worksheets in xls

Nilesh Buddha · March 2nd, 2006, 04:58 PM posted to microsoft.public.excel.charting

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 · March 3rd, 2006, 03:42 AM posted to microsoft.public.excel.charting

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mix chart types	Ken Murray	Powerpoint	7	April 28th, 2006 02:50 AM
How do I create a comparison chart from a data list?	comic guy	Charts and Charting	2	September 19th, 2005 01:38 PM
Use the same cell from many worksheets to create a chart?	Hightower	Charts and Charting	1	June 14th, 2005 01:14 PM
How do I get 3 series in sync with the x-axis?	zizbird	Charts and Charting	10	October 25th, 2004 01:23 PM
Create a separate chart for each row in Excel, then merge to word	Elbe Elemjay	Charts and Charting	1	September 8th, 2004 03:03 AM