You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have a chart that is displaying zero values because some cells it is charting formula's result is a zero due to the fact that as yet no data for that month has been entered.
I do not want the chart line to crash to the x axis.
Can anyone help?
Let's say the series that has formulas that sometimes produce 0 are in column C starting at row 2.
Set up a new Column D and in D2 put the formula =IF(C2=0,"",C2) and fill it down. This will show the same values as in C except that the 0s will be replaced by the null string, which won't plot.
Then base the chart on Column D rather than column C.
SG
Let's say the series that has formulas that sometimes produce 0 are in column C starting at row 2.
Set up a new Column D and in D2 put the formula =IF(C2=0,"",C2) and fill it down. This will show the same values as in C except that the 0s will be replaced by the null string, which won't plot.
Then base the chart on Column D rather than column C.
SG
Hi at present the cells which have a zero in, have so because the cell formula is returning the value zero.
Therefore I can only remove the zero by removing the formula and reinstating it when I update the data in the cells that it is pointing to.
Thank you so much it worked!!! The table I am plotting from is taking data from another table. Therefore instead of creating another column in the table I’m charting from, I just substituted the advice re creating another column D used the cell in the formula from the table I was using to calculate my data from.
If you do not want those data points to appear o the chart, leave the cells providing those data points empty.
Regards,
Barry
Prevent zero values from appearing in "Numbers charts"
