How can I prevent a Chart from showing zero values?

[Quinn Ramsey]

I am creating a chart, and sometimes the data will exist such that there are
points that I would like ignored. These points are determined by an If
statement, so I can place any string in there when I want them ignored, but I
have not been able to find a string that will result in the points not being
shown on the chart. Simply put, I am looking for a value that the chart will
ignore or another way to accomplish the same ends.

 

[Andy Pope]

Hi,

Try using NA() instead of ""

Cheers
Andy

I am creating a chart, and sometimes the data will exist such that there are
points that I would like ignored. These points are determined by an If
statement, so I can place any string in there when I want them ignored, but I
have not been able to find a string that will result in the points not being
shown on the chart. Simply put, I am looking for a value that the chart will
ignore or another way to accomplish the same ends.

 

[Quinn Ramsey]

Thanks a bunch, that fixed the chart issue. I would like the data to look
nice as well though. When I use NA() it puts #N/A in the cell. Is there a
way to have the chart work and the cell show a blank?

 

[Andy Pope]

You could use Conditional Formatting, checking for cell being ISNA(), to
set the font to be the same as the cell colour.

 

[olasa]

Hiding Labels that Show Zero Value:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon014

HTH
Ola Sandströ