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!
MacBook Pro, iOS 6.1.4