software

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

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
PeltierTech.com/
_______

quot;khquot; gt; wrote in message
news
gt;I have a dynamic chart of 10 sheets. All these sheets has contineous data
gt;in
gt; coloum B, and one chart, using offset(). Can I use one offset to refere to
gt; these data.
gt; Presently, I am using 10 offsets for those 10 charts. Any one could help
gt; please.
gt; In case I have 20 sheets, how can I do it.
gt; Kh