ExcelBanter - Dynamic chart

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Dynamic chart (https://www.excelbanter.com/charts-charting-excel/74180-dynamic-chart.html)

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" 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