Hi David - really sorry i called you Bernard earlier.

I just realised that if i select the chart, and go tools/options/chart that
the plot empty cells as (not plotted - leave gaps) is greyed out. That would
be the option i would expect to fix this
Why would i not be able to select this option.

Many Thanks
Matt

David Biddulph wrote:
Are you sure that you have =NA() ? Those are opening and closing
parentheses. Did you type someting into your formula, or copy from the
newsgroup?
Perhaps you can copy back from your formula bar to the newsgroup so that we
can see exactly what you've got in the formula which is returning #NAME?
--
David Biddulph

Hi Bernard - This now returns #NAME? and the graphs still plots them as
zero?
[quoted text clipped - 12 lines]
Regards
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200910/1