dynamic ranges in excel 2007

G

Guest

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?
 
G

Guest

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
 
B

Bernard Liengme

If your purpose is ALWAYS to chart ALL the data in the range, then:
Make the range an Excel Table.
The chart automatically changes as the table increases or contracts.

I'll let Jon solve the OFFSET issue

best wishes
 
J

Jon Peltier

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
 
G

Guest

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?
 
J

Jon Peltier

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

jp at-sign peltiertech dot com

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top