How can I prevent a Chart from showing zero values?

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.

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

HTH
Ola Sandström

Hi,

Try using NA() instead of ""

Cheers
Andy

Quinn Ramsey wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info

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" wrote:

> Hi,
>
> Try using NA() instead of ""
>
> Cheers
> Andy
>
> Quinn Ramsey wrote:
> > 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, Microsoft MVP - Excel
> http://www.andypope.info
>

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


Quinn Ramsey wrote:
> 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" wrote:
>
>
>>Hi,
>>
>>Try using NA() instead of ""
>>
>>Cheers
>>Andy
>>
>>Quinn Ramsey wrote:
>>
>>>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, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

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