| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic chart
I have a dynamic chart of 10 sheets. All these sheets has contineous data in
coloum B, and one chart, using offset(). Can I use one offset to refere to these data. Presently, I am using 10 offsets for those 10 charts. Any one could help please. In case I have 20 sheets, how can I do it. Kh |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart
Do the offset formulas refer to different ranges? Then they are unique, and
you need them all. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "kh" wrote in message ... I have a dynamic chart of 10 sheets. All these sheets has contineous data in coloum B, and one chart, using offset(). Can I use one offset to refere to these data. Presently, I am using 10 offsets for those 10 charts. Any one could help please. In case I have 20 sheets, how can I do it. Kh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Dynamic bar chart, must ignore "n/a" data... | Charts and Charting in Excel | |||
| dynamic end on chart | Charts and Charting in Excel | |||
| how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Linear Mode
