I have read the posts about Excel charts plotting cells that are
empty. I'm not sure I understood what I read, and our particular
circumstances may be a bit different. (I'm not sure.)

Anyway. Our problem is:
We use Excel 2003 MSQuery to extract the results of an Access query
and automatically put them in an Excel spreadsheet. Depending on the
circumstances, the query doesn't always return the same amount of
data. In order to automatically expand or shrink the range of cells
that actually contain data, we use the OFFSET function
DonationsTotals=OFFSET(Donations!$K$2,0,0,COUNTA(D onations!$K:$K),1).
From this data, we have a chart that is supposed to plot only the
cells that are not empty: =NewReport.xls!DonationsTotals.
This works great except that the resulting column chart appears to be
plotting cells (at the far right) that don't have any data in them.
Makes for an odd looking chart,

Can anyone suggest a solution to this problem? (In terms a rookie
like me could understand). We would be ever so grateful.
Thanks very much for your time!!!
S