[Dba-office] Excel chart question

I know how to use =NA() to remove a blank value from a chart. What I can't
figure out is how to remove that same blank value from the X axis. I've
read lots of fixes, but nothing actually works. Either I'm applying them
wrong or my setup just doesn't match the requirements.

The only way I know to achieve this is to use a filter to remove the row
from the dataset altogether. A reader finds this impractical. He wants
something more dynamic. I suppose I can give him a macro that resets the
filter each time.

Susan H.