In an Excel chart I have data linked to an MS Access query. The number of
rows and columns for the query may vary. To cover this, I have pasted over a
larger area of cells that I am likely to receive rows/columns in Access. I
now want to plot this data on a chart.

When selecting the data source for the graph as the full potential range of
cells from the Access query, the graph plots the #N/A values which result
from the cell range being large than the Access query. How can I get the
chart to ignore the #N/A values like it can be set to ignore zero values?