Forum Discussion
Line charts show zero or #N/A value as zero not as gap even after checking the hidden cell box.
I am trying to create a simple Line chart for and not have zero or #N/A show up on the chart. I have watched a bunch of videos and tried several different formals to hide the points but the still sh...
I added your formula and followed the steps and got a No cells Found response and the same chart I had before.
My original formula
=IF(AM7<1,"",SUM($AG$7:AG7))
Select the cell where your original formula is
Go to Conditional Formatting
Select New rule
go to Use the formula to determine the cells to be formatted
Instead of B1, enter the cell in which your formula is
=ISTNV(B1) abc
that's how it should work...or not?
Nikolino
Go to Conditional Formatting
Select New rule
go to Use the formula to determine the cells to be formatted
Instead of B1, enter the cell in which your formula is
=ISTNV(B1) abc
that's how it should work...or not?
Nikolino
- if it shouldn't work
Suppress a # NV message with ISNV at VLOOKUP
https://www.computerwissen.de/office/excel/artikel/mit-istnv-beim-sverweis-eine-nv-meldung-unterdruecken.html
I know I don't know anything ... I don't know more