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 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

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

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390546