I am trying to set up dynamic chart based on a pull from a
database...the results look something like so: volume across with
months on the top:
Jan | Feb | March
123 | 234 | 345

This info is being pulled monthly by an end user and I want to have a
chart that displays the volumes. I would like for the chart to change
automatically when a new month is added. I tried to use range names by
defining it in the following fashion:

=OFFSET('Volume'!$A$2, 0, 0, 1, COUNTA('Volume'!2:2))

This works just fine once, but as soon as I add another column, nothing
happens! and the range definition changes all the time (for example, i
get this: =OFFSET('Volume'!$A$4, 0, 0, 1,
COUNTA('Volume'!65527:65527)))

No idea why it does not automatically update the chart & no idea why
the range definition changes...Please help!


--
sergv
------------------------------------------------------------------------
sergv's Profile: http://www.excelforum.com/member.php...o&userid=26927
View this thread: http://www.excelforum.com/showthread...hreadid=401480