I am working on a year-end report for my clients that shows them information
associated with their accounts. Most of the information on each client's
reports relates to the current year and is easy to retreive from the tables
that store all the clients' information. However, there is historical
information for each client that is more difficult to report.

I want to display a graph for each client showing the year-to-year change in
"value" for them. But since each client has a different number of data
points, it is proving hard for me to format the graphs properly.

I have built a query to trap the pertinent data for each client, whether it
is 1 record or 20 records. But I cannot figure out how to have a variable
range named in the graph's parameters based on how many rows the particlar
client might have. I tried naming a "super-set" of records...that is I
hightlighted a range including 40 rows, which will always include all of the
client records, whether there is 1 or 15..but the blank rows actually get
included as data points in the graph.

One possible solution path. In anticipation of this sort of problem, I
included a START DATE and END DATE variable for each client..but I cannot
seem to find a way to use those variables in naming my range. These ended up
being used in the query...

Any ideas would be appreciated.

regards,
Tom