Recently, we rleased a big UserVoice request that customers have been asking for over the last several years, https://support.office.com/en-us/article/Display-empty-cells-null-N-A-values-and-hidden-w...
Updated Sep 21, 2017
Version 2.0
Blog Post
Hey thanks for this.
However, I dont know why, in my Excel file (Excel 2010) I cannot prevent the graph from showing blanks or #N/A as 0 values.
The "show #N/A as empty" doesnt option doesnt appear on the data selection window, and I can try any option ("gaps", "zero", "connect data.."), the graph just appears the same, with empty values as 0.
How can I solve that ?
Thanks in advance.