Andy,
If I use "NA()" then it places a "#NA" in the excel spread sheet due to that
condition. This defeats the purpose of formating my sheet to leave blanks. By
leaving blanks there is less information on the sheet and it looks much more
professional/neat.

Is there another way?

Thanks

"Andy Pope" wrote:

Hi,

The blank part of your formula should be NA() rather than "".

=IF( test , value , NA() )

More information here
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy

groj wrote:
In my series data, the blank is created by an if statement so there is a
calculation here that makes the cell blank. should it still not plot it as
zero?
I looked where you mention, and I am already set up to plot emplty cells as
not plotted. But there are still zeros being plotted.

any help?
thanks

"John Mansfield" wrote:


hlp,

Click once on your chart. Then, go to the standard toolbar and go to Tools
- Options - Chart - Plot empty cells as: Not plotted (leave gaps).

----
Regards,
John Mansfield
http://www.pdbook.com

"hlp" wrote:


How do I exclude blank cells in diagrams. If I have an area of data and among
these data some is blank. How do I get excel to not display these data as '0'
but just to skip the cell.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info