Apple Intelligence is now available on iPhone, iPad, and Mac!
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"
