Hi,

What exactly does 'not working' mean? What type of chart?

The use of NA() in a line chart will only suppress the displaying of a data
marker. The line will be interpolated between real data points.
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
Hi,

I have a chart I am trying to create, however, i not want to plot the
empty ranges.
I have used the NA() option in my formulas so that it does not get
plotetd on my graphs but it is not working.

How can I fix this error?