Hi, I don't want my blank cells to appear anywhere on my chart. I want it to
ignore the cooresponding cell if the cell has #NA in it. Write now, I have
over 10,000 cells, but only 50 have results but the chart is trying to chart
the entire workbook.

"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