Are the #N/A values all at the end of the range? If so, using the COUNT
function should let you size the range to include only the numbers. Suppose
the data in A1:B7 looks like this:

X Y
1 1
2 3
3 5
4 7
5 #N/A
6 #N/A

Define a name 'Yvalues' that refers to:
=OFFSET(B1,1,0,COUNT(B:B),1)

and a range 'Xvalues' that refers to:
=OFFSET(Yvalues,0,-1)

Set up the chart to use Sheet1!Xvalues and Sheet1!Yvalues, or edit the
series formula to read:

=SERIES(Sheet1!$B$1,Sheet1!Xvalues,Sheet1!Yvalues, 1)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
Thank you for your help, and sorry for my delay.

Jon, you're right, I want to create a dynamic chart. I've had some
success with that in the past; however, I can't figure out how to get
that to work with this problem.

The formulas themselves are dynamic - they constantly update
themselves for each year and month, but I don't know how to make my
chart dynamic as well. Whenever I try, I usually end up graphing the
#N/A data, which gives me blank values on my chart.

Can you give me some more directed help so that I no longer grab the
#N/A data to chart? I want my x-axis to only include months with real
data.

Thank you again.
-bgetson