Dynamic chart

kh · February 27th, 2006, 04:51 PM posted to microsoft.public.excel.charting

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 · March 1st, 2006, 12:38 AM posted to microsoft.public.excel.charting

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
news

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form as dynamic chart map	Jose Lopes	Using Forms	0	February 23rd, 2006 10:20 PM
Querie for a dynamic chart	Jose Lopes	Running & Setting Up Queries	0	February 23rd, 2006 10:16 PM
Dynamic Excel chart in PowerPoint...	Rob	Powerpoint	5	November 5th, 2005 03:32 AM
Creating a dynamic chart for an engineering spreadsheet	Cal@tech-etch	Charts and Charting	1	November 3rd, 2004 07:50 PM
Dynamic Offsetting, Names, Arrays, Range, Chart Values. NEED HELP	Bob Lidgard	Worksheet Functions	14	February 25th, 2004 03:26 PM