Dcount

[Paulwilson412]

Hi,

I have a spread sheet that I have to enter data into and what I'
trying to do is produce a graph that shows how many new enteries hav
been put in for say last month, so what I need is for a formula t
count up how many rows there are. The trouble is that I cant specif
where the range is as it gets bigger with the more enteries i put in??

Can I use DCOUNT for this, if so can anyone expalin what the database
field, and criteria are as the help file on this doesnt give me an
idea at all?

Thanks for any help you are able to give!

Paul

 

[Jason Morin]

What you need to do is create some dynamic ranges using
OFFSET as the source for your graphs. While this may not
be what you're looking for, it'll put you in the right
direction. You'll find a bunch of links to examples here:

http://www.peltiertech.com/Excel/Charts/DynamicChartLinks.
html

HTH
Jason
Atlanta, GA

 

[Don Guillett]

try using a defined name for your graph series
insert>name>define>colA
in the refers to box
=offset($a$1,0,0,counta($a:$a),1)
have a look in HELP index for OFFSET

 

[Paulwilson412]

I'm now on the right track!

Than

 

[Don Guillett]

glad to help. Ask again if you need more help.