You can do it with names if you don't use lists. I presume one could define
names in a different clever way to overcome the problem.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Thu, 3 May 2007, in microsoft.public.excel.charting,
Jon Peltier said:
Pretty neat, unfortunately in breaks down if the data is in an Excel 2003
list, because the list will incorrectly modify the definition of the names
if the size of the list changes.

If you can't do it with names in XL2003, can you do it with OFFSET?

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.