Forum Discussion
smherring4
Jul 10, 2020Copper Contributor
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...
NikolinoDE
Jul 11, 2020Gold Contributor
To hide #NV, you can use Conditional Formatting,
Manage Rules,
New Rule,
Use the formula to determine the cells to be formatted,
Insert the formula "= ISTNV (B2)" and Format the cell as desired.
or with VLOOKUP ... small example below.
Sheet with name 'Tabelle3'
A B
1 A #NV
2 B #NV
3 C #NV
Cell Formel
B1 =SVERWEIS(A1;E:F;2)
B2 =SVERWEIS(A2;E:F;2)
B3 =SVERWEIS(A3;E:F;2)
Cell Conditional Formatting... Format
B1 1: =ISTNV(B1) abc
B2 1: =ISTNV(B2) abc
Short answer if it worked would be good: -) ... even if it didn't work ... You can never stop learning 🙂
Nikolino
Manage Rules,
New Rule,
Use the formula to determine the cells to be formatted,
Insert the formula "= ISTNV (B2)" and Format the cell as desired.
or with VLOOKUP ... small example below.
Sheet with name 'Tabelle3'
A B
1 A #NV
2 B #NV
3 C #NV
Cell Formel
B1 =SVERWEIS(A1;E:F;2)
B2 =SVERWEIS(A2;E:F;2)
B3 =SVERWEIS(A3;E:F;2)
Cell Conditional Formatting... Format
B1 1: =ISTNV(B1) abc
B2 1: =ISTNV(B2) abc
Short answer if it worked would be good: -) ... even if it didn't work ... You can never stop learning 🙂
Nikolino