How can I prevent a Chart from showing zero values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi,

Try using NA() instead of ""

Cheers
Andy

Quinn said:
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.
Click to expand...
 
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?
 
You could use Conditional Formatting, checking for cell being ISNA(), to
set the font to be the same as the cell colour.
 
Back
Top