Email me off-line. If it's a simple problem, I won't bother with all that.

jp at-sign peltiertech dot com

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


"onzilla" wrote in message
...
Jon,

I am sorry to trouble you with this.. I figured out I was doing something
else wrong. It is complex worksheet.

How much do you charge for consulting per hour?

"Jon Peltier" wrote:

I can't reproduce your issue. I entered your exact formula as the
refers-to
formula for a range, then used the range in the series formula, and the
series became dynamic, as expected.

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


"onzilla" wrote in message
...
Range 'Refers To'

=OFFSET($A$1,0,0,COUNT($A:$A),1)

the purpose of this, of course, would be that you can run that graph
and
have the range work automatically for different sized data sets..
without
having to mannually re edit the range.

Jono

"Jon Peltier" wrote:

How are you defining the ranges?

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


"onzilla" wrote in message
...
i had some dynamic ranges working for charts in excel 2003 - now I
have
'upgraded' to 2007 and the dynamic range for charts don't work.
(they
work
when in compatibility mode, but not when save as new 2007 xls).

Any ideas?