Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to create chart using data on different worksheets in xls
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get data from a web page to chart in excel. Any solutions? | Charts and Charting in Excel | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
how do I create a chart from data stored in MS Word | Excel Discussion (Misc queries) | |||
How do I chart the same data cell on a range of worksheets? | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) |