Excel 2016 interpolating between NA in plot even after selecting Show Empty Cells as: Gaps
Hi, I had several plots where I had chosen the option "Show Empty Cells as: Gaps" and it was working great: However, today I re-opened the file, and it looked like this: I checked, and the option was still active: I have no idea why this is happening and it has been an incredible waste of time! I researched a little more about it, and in that same Hidden and Empty Cell Settings window, there should be an additional option that says Show #N/A as an empty cell (See step 5 here: https://support.office.com/en-us/article/display-empty-cells-null-n-a-values-and-hidden-worksheet-data-in-a-chart-a1ee6f0c-192f-4248-abeb-9ca49cb92274?NS=EXCEL&Version=16&SysLcid=1033&UiLcid=1033&AppVer=ZXL160&HelpId=90807&ui=en-US&rs=en-US&ad=US). However, as you can see in the image above, that option does not appear for me. Can someone please help me to fix this? I am also attaching an example spreadsheet that has the issue. Thanks!
