Recently, we rleased a big UserVoice request that customers have been asking for over the last several years, #N/A being rendered as blank in charts. Thank you to those who voted and have been patien...
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.