I created an Excel/PowerPoint chart and I don’t want the zeros to be graphed. I clicked the option to ”not plot empty cells” but I am using a formula to create the data. Because the cell contains a formula, Excel is not recognizing this as an empty cell and plots it as zero. How can I change the chart so it does not to plot the formula as “zero”?
Add an “if” statement with “NA()” to your formula.
Example - if cell A1 contains zero, use this formula
The cell will now show #N/A. Excel and Powerpoint charts do not graph #N/A’s
If you liked my post, feel free to subscribe to my rss feeds