title: Ignore #'¡DIV/0! Values in both axes of a bar chart - Excel
body: <p>I have this bar chart in excel :</p>
  
  <p><img src="https://i.stack.imgur.com/RvSOw.png" alt="enter image description here"></p>
  
  <p>As you see, if there is <code>#'¡DIV/0!</code>, the values are <code>0</code>. What I really want is that the bar chart just shows the numeric values. In this case. just the first three values would have to be visualized. I tried the formula <code>IF.ERROR(FORMULA,"")</code> but the result was the same,</p>
  
  <p>So, How Can I do that?</p>