Dynamic chart

[kh]

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

 

[Jon Peltier]

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/
_______