That did the trick. Thank you very much!
Jon Peltier wrote:
Is it when you have "any" #N/A values, or when a series' entire range
contains #N/A? I presume it's the latter. VBA chokes on XY and Line charts
when an entire series is unplottable due to blanks of #N/A. The standard
answer is to make a column chart, then change it to a line chart after
you've done all the other manipulation of the chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
I was told in the programming group to come here. I have a problem I'm
hoping
[quoted text clipped - 53 lines]
Application.ScreenUpdating = True
End Sub