Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How can I make a chart ignore cells until their value is changed from 0?

In the corresponding table, I used conditional formatting to hide zeros in the highlighted row by conditionally changing the text color to that of the table background. However, the zero value's are still represented in the corresponding chart as you can see in the attached photo . How can I make the chart ignore certain cells only until their values are changed from zero? Thanks in advance!


RyanUser uploaded file

MacBook Pro, iOS 6.1.4

Posted on Aug 31, 2013 10:14 PM

Reply
Question marked as Best reply

Posted on Aug 31, 2013 11:07 PM

Hi Ryan,


Leave the cells empty until they're needed, or, if the cells' contents are determined by a formula, revise the formula to insert a null string if the value is zero.


=IF(your formula = 0, "", your formula)


Regards,

Barry

1 reply

How can I make a chart ignore cells until their value is changed from 0?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.