Thread: 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

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" <kh@discussions.microsoft.com> wrote in message
news:D35A8EE8-1A36-4549-AA7A-493685D0F45C@microsoft.com...
>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